Count Issues

From: Dev <dev(at)umpa-us(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Count Issues
Date: 2004-10-14 20:54:56
Message-ID: 6.1.0.6.2.20041014164509.024ac3c0@pop3.umpa-us.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Holden 2004-10-14 21:00:51 Possibly stupid questions re: large tables/files, port 5432 access
Previous Message Lee Harr 2004-10-14 20:52:33 Re: psycopg help