Re: Count Issues - Mailing list pgsql-general

From Steven Klassen
Subject Re: Count Issues
Date
Msg-id 20041014210305.GA18037@commandprompt.com
Whole thread Raw
In response to Count Issues  (Dev <dev@umpa-us.com>)
List pgsql-general
* Dev <dev@umpa-us.com> [2004-10-14 16:54:56 -0400]:

> I am trying to get a total number of rows returned form a query.
>
> SELECT count(this) from table group by this

Remove the 'group by' clause -- you don't need it.

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

pgsql-general by date:

Previous
From: Andre Maasikas
Date:
Subject: Re: Count Issues
Next
From: John Sidney-Woollett
Date:
Subject: Re: Count Issues