Flashcards in Ch. 8 Deck (12):
________ is the process referred when you want to see only records meeting certain conditions.
_____ _______ is used to specify conditions that must be true for a record to be included in query results.
_____ ___ ______ is used to specify the sorted order for displaying query results.
ORDER BY clause
_________ _______ ______ are used to indicate how a record should relate to a specific search value.
Mathematical comparison operators
A _______ identifies what must exist or a requirement that must be met for a record to be included in the results.
A _______ _______ indicates how data should relate to the search value, such as >.
The ____ operator is unique, in that its used with wildcard characters to search for patterns.
_______ _______ are used to represent one or more alphanumeric characters.
The LIKE operator includes the _______ option for indicating when wildcard symbols should be used as literals rather than translated as wildcard characters.
What is the order in which operators are resolved?
1. Arithmetic operations
2. Comparison operators (, =, LIKE)
3. Logical operatoras [in this order (NOT, AND, OR)}
A ______ ______ means no value has been stored in that field.