Multiple choice technology databases

Arrange the keyword “FROM, WHERE, SELECT, HAVING,GROUP BY, ORDER BY ” in the proper ?order

  1. SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?

  2. SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY

  3. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

  4. SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL clause order: SELECT specifies columns, FROM names the table, WHERE filters rows before grouping, GROUP BY aggregates, HAVING filters groups, and ORDER BY sorts final results. HAVING must come after GROUP BY and before ORDER BY.

Keep practicing — related questions