The SQL ORDER BY clause is used to sort the result-set, it can only be used in SELECT statements.
The AND/OR operators are used to create an SQL statement based on 2 or more conditions in SQL WHERE clause. They can be used in SELECT, UPDATE, DELETE or INSERT statement.
The AND operator selects records if all the conditions in WHERE clause are true at the same time. The OR operator selects records if any conditions in the WHERE clause are true.
The SQL INSERT INTO statement is used to insert one or multiple records to a database table.
The SQL WHERE clause is used to filter records by adding it to an SQL statement – SQL Select, update, delete, insert statement.
The SQL DELETE Statement is used to remove single record or multiple records from a database table.
The SQL UPDATE statement is used to update data stored in database tables.
The SQL SELECT DISTINCT statement is used to select distinct(different, unique) value of centain database table column(s), and remove the duplicates from the result. The usage of this statement is same among MS SQL Server, Oracle, MySQL.
The SQL SELECT INTO statement has different implementations from one product to another. This topic will talk about its implementations in MS SQL Server, Oracle and MySql.
The SQL SELECT statement is used to select data from SQL database.
It returns a result-set which stores the result as a table.