Re: Count Issues

From: Andre Maasikas <andre(dot)maasikas(at)abs(dot)ee>
To: Dev <dev(at)umpa-us(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Count Issues
Date: 2004-10-14 21:02:56
Message-ID: 416EE980.2060701@abs.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!
>
SELECT COUNT(DISTINCT this) FROM table

Andre

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Klassen 2004-10-14 21:03:05 Re: Count Issues
Previous Message Thomas F.O'Connell 2004-10-14 21:01:51 Re: Boolean