SQL applies predicates in the                 clause after groups have been formed, so aggregate functions may be used.

Related MCQs

• If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
• ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
• The UNION SQL clause can be used with _____________
• ‘AS’ clause is used in SQL for
• Which SQL function is used to count the number of rows in a SQL query?
• Aggregate functions are functions that take a                        as input and return a single value.
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• What is the purpose of the SQL AS clause?
• The UPDATE SQL clause can _____________
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.