Which of the following SELECT statements will select the ProdNum field from the tblProducts table,and then sort the records in descending order by the Price field?
A)SELECT ProdNum FROM tblProductsSORT Price DESC
B)SELECT ProdNum FROM tblProductsORDER BY Price DESC
C)SELECT ProdNum FROM tblProductsWHERE Price DESC
D)SELECT ProdNum FROM tblProductsORDER BY ProdNum DESC

Question

Quizplus · Accepted Answer

The correct syntax for sorting a result set in descending order is "ORDER BY column_name DESC", therefore the correct statement would be "SELECT ProdNum FROM tblProducts ORDER BY Price DESC". Option A is incorrect as "SORT" is not a valid keyword in SQL. Option C is incorrect as "WHERE" is used to filter rows based on a condition, not for sorting. Option D sorts the result set by ProdNum in descending order, not Price.

Which of the Following SELECT Statements Will Select the ProdNum