Question: SELECT DISTINCT COUNT ( V _ CODE ) FROM PRODUCT; SELECT COUNT ( DISTINCT V _ CODE ) FROM PRODUCT; a . The difference is
SELECT DISTINCT COUNT VCODE FROM PRODUCT;
SELECT COUNT DISTINCT VCODE FROM PRODUCT;
a The difference is in the order of operations.
b The second command applies the DISTINCT keyword to the VCODEs 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 VCODE 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
