The HAVING clause is used to restrict the groups returned by a query.
Correct Answer:
Verified
Q27: Group functions can only be nested to
Q28: A SELECT statement cannot include both a
Q29: Columns used to group data in the
Q30: SUM,AVG,and COUNT are all considered group functions._
Q31: The WHERE clause specifies which groups will
Q33: When the SELECT statement includes both WHERE
Q34: The COUNT(*)function can be used to count
Q35: The TOTAL function is used to calculate
Q36: The optional DISTINCT keyword instructs Oracle12c to
Q37: The AVG function only includes non-NULL values
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents