SQL – DEFAULT Keyword
The DEFAULT keyword provides a default value for a column that will be added to all new records if no other value is specified.
SQL – DISTINCT Keyword
The DISTINCT keyword returns only different values (no two values the same) in the result set.
SQL – DROP Keyword
The DROP keyword is used to delete existing columns, constraints, databases, indexes, tables, and views.
SQL – EXISTS Keyword
The EXISTS keyword tests for the existence of any record in a subquery, and returns “true” if the subquery returns one or more records.
SQL – FOREIGN KEY Keywords
The FOREIGN KEY keywords are a key (a field or fields in one table that refers to the PRIMARY KEY in another table) used to link two tables together.
SQL – FULL OUTER JOIN Keywords
The FULL OUTER JOIN keyword returns all rows when there is a match in either the left table or right table.
SQL – GROUP BY Keywords
The GROUP BY keywords are used to group the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG).
SQL – IN Keyword
The IN keyword allows you to specify multiple values in a WHERE clause, and is shorthand for multiple OR conditions.
SQL – INDEX Keyword
Indexes are used to speed up the retrieval of data (searches/queries) from the database.
SQL – INNER JOIN Keywords
The INNER JOIN keywords returns rows that have matching values in both tables.
SQL – INSERT INTO SELECT Keywords
The INSERT INTO SELECT keywords copies data from one table and inserts it into another table.
SQL – IS NOT NULL Keywords
The IS NOT NULL keywords are used to test for non-empty values (NOT NULL values).
SQL – JOIN Keyword
The JOIN keyword is used in an INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN to return matching rows from two tables.