SQL – LEFT JOIN Keywords
The LEFT JOIN keywords return all rows from the left table, and the matching rows from the right table (NULL from the right side if there is no match).
SQL – LIKE Keyword
The LIKE keyword is used in a WHERE clause to search for a specified pattern in a column. It can use two wildcards: % and _.
SQL – NOT Keyword
The NOT keyword is used with other SQL keywords to only include rows where a condition is NOT true.
SQL – NOT NULL Keywords
The NOT NULL keywords enforces a column to NOT accept NULL values (a record cannot be inserted/updated without adding a value to that field).
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).