Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
SQL clause that restricts retrieval to groups.
SQL clause that restricts retrieval to rows.
SQL clause that sorts output.
Aggregate function to calculate a total.
SQL clause that restricts retrieval to groups.
Symbol that indicates not equal to samparison operator.
Symbol that indicates all fields are to appear in query result.
Operator used to sort resards in descending order.
Operator used to eliminate duplicate values.
SQL clause to use with subqueries.
Responses:
DESC
HAVING
IN
AS
< >
asterisk (*)
WHERE
SUM
DISTINCT
ORDER BY
Correct Answer:
Premises:
Responses:
SQL clause that restricts retrieval to groups.
SQL clause that restricts retrieval to rows.
SQL clause that sorts output.
Aggregate function to calculate a total.
SQL clause that restricts retrieval to groups.
Symbol that indicates not equal to samparison operator.
Symbol that indicates all fields are to appear in query result.
Operator used to sort resards in descending order.
Operator used to eliminate duplicate values.
SQL clause to use with subqueries.
Premises:
SQL clause that restricts retrieval to groups.
SQL clause that restricts retrieval to rows.
SQL clause that sorts output.
Aggregate function to calculate a total.
SQL clause that restricts retrieval to groups.
Symbol that indicates not equal to samparison operator.
Symbol that indicates all fields are to appear in query result.
Operator used to sort resards in descending order.
Operator used to eliminate duplicate values.
SQL clause to use with subqueries.
Responses:
Related Questions
Q37: The _ wildcard represents any sallection of
Q87: Less than ( ), and NOT (not
Q88: To begin creating a new SQL query,
Q89: The _ query enables you to send
Q90: To sort output in a SQL statement,
Q91: Using or interfacing with SQL Server requires
Q93: In SQL queries, you can enclose text
Q94: If you want to list all the
Q95: When simple criteria are sannected by the
Q97: To create a SQL query that does