Grant

South Africa

Apr
27
comment Bash one-liner to delete only old kernels
Tried this but I get error: "ubuntu-old-kernel-cleanup: command not found"
Mar
4
answered Check if cookies are enabled
Mar
3
awarded Supporter
Feb
16
accepted COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
deleted 14 characters in body
Feb
14
answered COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 18 characters in body
Feb
14
comment COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
As mentioned in the question the output must equal the "Desired result:" table in my question that is what I want as output: uniqVisits = 2345, bounced = 325, month = 2015-10 per row.
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 93 characters in body
Feb
14
comment COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
@SamiKuhmonen it is just a count, there are 100000's of values in the table, your request is not feasable. Also someone has edited out my actual values, but it is irrelevant as we are just counting the number of cid many of which contain duplicate data ie the same cid string value
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 38 characters in body
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 54 characters in body
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 54 characters in body
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 722 characters in body
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 722 characters in body
Feb
14
revised COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
added 722 characters in body
Feb
14
asked COUNT DISTINCT + COUNT GROUP BY HAVING (value) + GROUP BY months
Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
I appreciate the detail you have supplied in this answer.... very insightful
Feb
1
comment Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
Thanks for the very thorough explanation, I didn't know how to get the sub queries wrapped together in one "Main query" I guessed it should have that structure but ...... SQL is not very intuitive :)
Feb
1
accepted Get COUNT() AND COUNT(DISTINCT()) values across 2 tables
1 2 3 4 5