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
>
