Multiple choice technology databases

What can be used in a SELECT statement to obtain search criteria for the SELECT statement?

  1. HAVING clause

  2. ORDER BY clause

  3. Subquery

  4. GROUP BY clause

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A subquery can be embedded in a WHERE clause to provide search criteria for the main SELECT statement. HAVING filters grouped results after aggregation, ORDER BY only sorts the output, and GROUP BY organizes data for aggregation - none of these provide search criteria.