View Single Post

   
  #7 (permalink)  
Old 02-28-2008, 09:18 AM
Bosconian
 
Posts: n/a
Default Re: Count(*) different than record count

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:Y_mdnbN4ks_K0LjYnZ2dnUVZ_rmdnZ2d@comcast.com. ..
> Bosconian wrote:
>> "Philipp Tölke" <ascii158@web.de> wrote in message
>> news:eg38ql$pqt$1@online.de...
>>
>>>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

>>
>>
>> It's amazing what a difference moving one parenthesis makes. :-)
>>
>> Many thanks.

>
> Yes, you were getting a distinct count - hence my question (trying to
> steer you onto the right course).
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================


Absolutely. Thanks for the clarification.


Reply With Quote