View Single Post

   
  #6 (permalink)  
Old 04-20-2008, 10:04 AM
bozon
 
Posts: n/a
Default 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.

Reply With Quote