Term
|
Definition
| Question represented in a way that the DBMS can understand |
|
|
Term
|
Definition
Conditional restrictions
Arithmetic operators
Logical operators
Special operators |
|
|
Term
|
Definition
Equal to
Less than
Greater than
Less than or equal to
Greater than or equal to
Not equal to |
|
|
Term
|
Definition
| Does not exist in the database but is computed using data in existing columns |
|
|
Term
|
Definition
Alternative name for a column
Use key word AS after the column name to specify an alias
Use double or single quotation marks if an alias contains spaces |
|
|
Term
|
Definition
Connects two or more simple conditions
AND
OR
NOT |
|
|
Term
|
Definition
|
|
Term
|
Definition
| checks whether attribute value is within a range |
|
|
Term
|
Definition
| checks whether attribute value is null |
|
|
Term
|
Definition
| checks whether attribute value matches any value within a value list |
|
|
Term
|
Definition
checks whether attribute value matches given string pattern
% matches any number of characters, even zero characters
_ matches exactly one character |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Eliminates duplicate values |
|
|
Term
|
Definition
Subquery
One query is placed inside another one
The inner query is executed first, then the outer query uses the result of the first query
Used if you have a multiple step operation
Use IN Operator |
|
|
Term
|
Definition
| Creates groups of rows that share common characteristics |
|
|
Term
|
Definition
WHERE limit rows
HAVING limit groups |
|
|
Term
|
Definition
| Slide 18 , 28 , 34 , 38 , 44 |
|
|
