Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT count(col) AS totalCount, count(distinct col) AS uniqueCount FROM ...
- SELECT count(col) AS totalCount
- , count(distinct col) AS uniqueCount
- FROM ...
- SELECT count(col) AS totalCount
- , count(distinct col) AS uniqueCount
- , count( case when ... then 1 end ) as conditional_count
- FROM ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement