Advertisements
Advertisements
प्रश्न
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
पर्याय
Both A and R are true and R is the correct explanation for A.
Both A and R are true and R is not correct explanation for A.
A is true but R is false.
A is false but R is true.
MCQ
उत्तर
A is false but R is true.
Explanation:
DISTINCT when given with COUNT, evaluates the expression for each row in a group, and returns the number of unique, nonnull values.
shaalaa.com
Functions in SQL
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
