Multiple choice technology databases

Which SQL statement selects all rows from a table called Products and orders the result set by ProductID column?

  1. SELECT * FROM Products ORDER BY ProductID

  2. SELECT * FROM Products WHERE ProductID > 200

  3. SELECT * FROM Products ORDERED BY ProductID

  4. SELECT ProductID FROM Products
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Option A correctly uses SELECT * to retrieve all columns and ORDER BY to sort by ProductID. Option C uses ORDERED BY which is invalid SQL syntax. Option B filters by WHERE condition, and Option D only selects the ProductID column.

Keep practicing — related questions