Re: Count Issues

Thank you all who helped me out on this..
I had tried the distinct but not inside the count.
I was using the group by because this could have multiple returns but after
adding the distinct to inside the count it worked like a charm!!!

Thanks to everyone who helped out on this one!

At 05:01 PM 10/14/2004, Dev wrote:
>Hello all,
>
>I am trying to get a total number of rows returned form a query.
>
>SELECT count(this) from table group by this
>
>Currently it is returning x rows with a count of each of the group by.
>
>I need the count of the rows returned!
>
>Any way to do this?
>
>
>
>----------
> Brian C. Doyle
>Director, Internet Services
>United Merchant Processing Association
><http://www.umpa-us.com>http://www.umpa-us.com
>1-800-555-9665 ext 212

----------

UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com>http://www.umpa-us.com
1-800-555-9665 ext 212