Count function will count all the values in the input expression even though if the values are repeating where as count distinct function will count only the distinct values both count and count distinct will ignores the null values.
Syntax
Count(expression)
Countd(expression)
Example:
Product Sales Count(sales) countd(sales)
Example:
Product Sales Count(sales) countd(sales)
A 100
B 100 4 3
C 200
D 300
E
B 100 4 3
C 200
D 300
E
No comments:
Post a Comment