Quote:Original post by ToohrVyk
+1 (well, the syntax is COUNT(DISTINCT surname) and the GROUP BY makes the first DISTINCT pointless, but you get the idea).
Um yeah. Blame incremental development. :)
Quote:Original post by spraff
Is it a happy side-effect of GROUP BY that DISTINCT(surname) limits its scope to the address at that row, or is that exactly what GROUP BY was designed for?
In this case the latter. Consider this obvious example:
SELECT COUNT(DISTINCT(surname))FROM Table1
This will count the number of distinct surnames in the table, right?
But now we would like to split (group) them by address:
SELECT COUNT(DISTINCT(surname))FROM Table1GROUP BY address
Profit!
