Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
A)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE

Question

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
A)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
B)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1];
C)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1);
D)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1};

Quizplus · Accepted Answer

The query in option A compares the value of the P_CODE field with the string '1558-QW1' using the less than operator (<). This will return all rows where P_CODE is alphabetically less than '1558-QW1'. Option B and C use the equals operator (=) to compare the P_CODE field with the numeric value 1558-QW1, which is not a valid value. Option D uses curly braces ({}) which is not the correct syntax for specifying a string value in a SQL query.

Which of the Following Queries Will Output the Table Contents