Term
| What does the "AND" operator do? |
|
Definition
| The AND operator allows multiple conditions to be combined. Records must match both conditions that are joined by AND to be included in the result set. |
|
|
Term
| What is the "AS" clause used for? |
|
Definition
| Columns or tables can be aliased using the AS clause. This allows columns or tables to be specifically renamed in the returned result set. |
|
|
Term
| What is the "OR" operator used for? |
|
Definition
| The OR operator allows multiple conditions to be combined. Records matching either condition joined by the OR are included in the result set. |
|
|
Term
| What is the "% wildcard" used for? |
|
Definition
| The % wildcard can be used in a LIKE operator pattern to match zero or more unspecified character(s). |
|
|
Term
| What is the SELECT statement used for? |
|
Definition
| The SELECT * statement returns all columns from the provided table in the result set. The given query will fetch all columns and records (rows) from the movies table. |
|
|
Term
| What is the "_ wildcard" used for? |
|
Definition
| The _ wildcard can be used in a LIKE operator pattern to match any single unspecified character. |
|
|
Term
| What is the "ORDER BY" clause used for? |
|
Definition
| The ORDER BY clause can be used to sort the result set by a particular column either alphabetically or numerically. (ASC or DESC) |
|
|
Term
| What is the "LIKE" operator used for? |
|
Definition
| The LIKE operator can be used inside of a WHERE clause to match a specified pattern. Such as: WHERE name LIKE 'Star%'; |
|
|
Term
| What is the "DISTINCT" clause used for? |
|
Definition
Unique values of a column can be selected using a DISTINCT query. Such as: "SELECT DISTINCT city
FROM contact_details;" |
|
|
Term
| What is the "BETWEEN" operator used for? |
|
Definition
| The BETWEEN operator can be used to filter by a range of values. The range of values can be text, numbers, or date data. |
|
|
Term
| What is the "LIMIT" clause used for? |
|
Definition
| The LIMIT clause is used to narrow, or limit, a result set to the specified number of rows. |
|
|
Term
|
Definition
| Column values can be NULL, or have no value. These records can be matched (or not matched) using the IS NULL and IS NOT NULL operators in combination with the WHERE clause. |
|
|
Term
| What does the "WHERE" clause do? |
|
Definition
| The WHERE clause is used to filter records (rows) that match a certain condition. |
|
|
