Which of the following queries is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?
A)SELECT ONLY V_CODE FROM PRODUCT;
B)SELECT UNIQUE V_CODE FROM PRODUCT;
C)SELECT DIFFERENT V_CODE FROM PRODUCT;
D)SELECT DISTINCT V_CODE FROM PRODUCT;

Question

Quizplus · Accepted Answer

The correct syntax to list unique values for a specific column is to use the keyword "DISTINCT" followed by the column name. Therefore, the correct query would be "SELECT DISTINCT V_CODE FROM PRODUCT" to list only those V_CODE values that are different from one another. Option A, B, and C are incorrect syntaxes for achieving the same objective.

Which of the Following Queries Is Used to List a Unique