Tag: sql query

SQL Query
Delete Statement:
Delete statement is used to delete data from table.
Delete statement without where clause affects all rows of table.
Syntax of Delete statement:
delete from <table_name>
where condition;
Delete can be rolled back.
Delete tables can have triggers.
Delete is DML command.
It does not reset identity

SQL Query
Update Statement:
Update statement enables to update existing data in a table.
Update statement without where clause affects all rows of table.
It can update one or more records in a table.
Syntax of Update Statement:
update <table_name>
set <column1>=<expression1>, <column2>=<expression2>,…., <columnN>=<expressionN>
where condition;
Here, column1, column2,…., columnN

SQL Query
Insert Statement:
Insert statement is used to insert data in to a table.
There are two basic syntaxes of the insert statement.
Syntax 1:
insert into table_name
values(value1, value2,….. ,valueN);
If you are adding values for all columns, you do not specify the column names.
Syntax 2:

SQL Query
SQL stands for structured query language.
Query may retrieve data from database.
SQL Queries are select, insert, update, delete etc.
Select Statement:
Select statement is used to retrieve data from one or more tables.
If you want to select all columns available in the table, use following syntax.
Syntax: