🎴 Flashcard Mode
SQL, DB2, and SSIS Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which SQL statement selects all rows from a table called Products and orders the result set by ProductID column?
AnswerClick to flip back
A
SELECT * FROM Products ORDER BY ProductID
💡 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.