Thread: Count(*) different than record count
View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 09:18 AM
Philipp =?UTF-8?Q?T=C3=B6lke?=
 
Posts: n/a
Default Re: Count(*) different than record count
Bosconian <nobody@nowhere.com> schrieb:
> I'm looking the latter, a count of distinct items.

The Syntax is COUNT(DISTINCT foo)

Cheers
--
Philipp Tölke
PGP: 0x96A1FE7A
Reply With Quote