SQL – OR Keyword
The OR keyword is used with the WHERE keyword to include rows where at least one of multiple conditions are true.
SQL – ORDER BY Keywords
The ORDER BY keywords are used to sort the result set using a specified column in ascending order (A – Z) or descending (Z – A) order.
SQL – PRIMARY KEY Keywords
The PRIMARY KEY keywords uniquely identifies each record in a table, which can have only one primary key consisting of a single field or multiple fields.
SQL – PROCEDURE Keyword
The PROCEDURE keyword is used with the CREATE keyword to create a stored procedure (prepared SQL code to be reused many times).
SQL – RIGHT JOIN Keywords
The RIGHT JOIN keywords returns all rows from the right table, and the matching rows from the left table (NULL from the left side if there is no match).
SQL – SELECT INTO Keywords
The SELECT INTO keywords copies data from one table and inserts it into another table.
SQL – SET Keyword
The SET keyword is used with UPDATE to specify which columns and values should be updated in a table.
SQL – TRUNCATE TABLE Keywords
The TRUNCATE TABLE keywords deletes all the data inside a table, but not the table itself.
SQL – UNION Keyword
The UNION keyword combines the result set of two or more SELECT statements (returning only distinct values).
SQL – UNION ALL Keywords
The UNION ALL keywords combines the result set of two or more SELECT statements (will return duplicate values).
SQL – USE Keyword
The USE keyword specifies the database you intend to work with. The statement is often made when starting work on or switching to a particular database.
SQL – VIEW Keyword
The VIEW keyword is used to CREATE a virtual table based on the result set of an SQL statement.
SQL – WHERE Keyword
The WHERE keyword filters a result set to include only records that fulfill a specified condition or set of conditions.