Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00? A)SELECT ProductDescription, Price FROM Products WHERE Price 50; B)SELECT ProductDescription, Price 50 FROM Products; C)SELECT ProductDescription, Price FROM Products WITH Price 50; D)SELECT ProductDescription, Price FROM Products WHERE Price

Question

Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?
A)SELECT ProductDescription, Price FROM Products WHERE Price > 50;
B)SELECT ProductDescription, Price > 50 FROM Products;
C)SELECT ProductDescription, Price FROM Products WITH Price > 50;
D)SELECT ProductDescription, Price FROM Products WHERE Price < 50;

Quizplus · Accepted Answer

Option A is correct because it uses the correct SQL syntax to select the specified fields from the Products table where the condition (Price > 50) is met.

Which of the Following SQL Statements Selects ProductDescription and Price