Re: Count Issues

From: Steven Klassen <sklassen(at)commandprompt(dot)com>
To: Dev <dev(at)umpa-us(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Count Issues
Date: 2004-10-14 21:03:05
Message-ID: 20041014210305.GA18037@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Dev <dev(at)umpa-us(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-10-14 21:09:09 Re: Count Issues
Previous Message Andre Maasikas 2004-10-14 21:02:56 Re: Count Issues