Select Statements: Special Operators and Aggregate Function Flashcards
Instructs the database engine to return information from the database as a set of records.
SELECT
Specifies which rows from the tables listed in the FROM clause are affected by the SELECT statement.
WHERE clause
Combines rows with identical values in the specified column-list into a single row.
GROUP BY clause
Specifies which grouped rows are displayed in a SELECT statement with a GROUP BY clause.
HAVING clause
Sorts a query’s resulting rows on a specified column or columns in ascending or descending order.
ORDER BY clause
Calculates the number of rows returned by a query.
COUNT
Returns the sum of a set of values contained in a specified column on a
query.
SUM
Returns the average of the values in a
group. Null values are ignored.
AVG
Returns the highest value in a group.
MAX
Returns the lowest value in a group.
MIN
Determines whether the value of an
expression falls within a specified range
of values.
BETWEEN…AND operator
Determines whether the value of an expression is equal to any of several values in a specified list.
IN operator
Checks for missing data or null values.
IS NULL operator
Used in conjunction with wildcard
characters to match character string
patterns.
LIKE operator
