Re: Count Issues

How about ...

select count(distinct this) from table

John Sidney-Woollett

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?
>
>
>
> ----------
>
> 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
>