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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
