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