Multiple choice technology databases

Choose the MANDATORY clauses of SELECT SQL statement

  1. SELECT

  2. WHERE

  3. GROUP BY

  4. FROM

  5. ORDER BY

  6. HAVING
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

The SELECT statement requires only SELECT and FROM clauses to be valid - these specify what to retrieve and where from. WHERE, GROUP BY, ORDER BY, and HAVING are optional clauses that filter rows, group results, sort output, and filter groups respectively. A query like 'SELECT column FROM table;' is perfectly valid.

Keep practicing — related questions