Question: SELECT DISTINCT COUNT ( V _ CODE ) FROM PRODUCT; SELECT COUNT ( DISTINCT V _ CODE ) FROM PRODUCT; a . The difference is

SELECT DISTINCT COUNT (V_CODE) FROM PRODUCT;
SELECT COUNT (DISTINCT V_CODE) FROM PRODUCT;
a. The difference is in the order of operations.
b. The second command applies the DISTINCT keyword to the V_CODEs before the count is taken so only unique values are counted.
c. The first command executes the Count function to count the number of values in V_CODE including duplicate values, and then the Distinct keyword only allows one count of that value to be displayed.
d. All of these choices are correc

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!