You are here
Home > Posts tagged "sql query"

SQL Query (DELETE Statement)

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)

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)

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 (SELECT Statement)

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:

Top