Re: Having problem with distinct and count Heck, Yeah.
I know this is a feature in other databases. A quick check of my book
"SQL in a Nutshell" gives the following definition:
"COUNT DISTINCT counts the occurences of all unique, non-null values in
the specified column(s)"
The paren "s" is a clear indication that you can use 1 or more columns. |