Re: Count Issues - Mailing list pgsql-general

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