Re: Counting Distinct Records

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Counting Distinct Records
Date: 2004-11-16 22:34:31
Message-ID: 20041116141911.K84773@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 16 Nov 2004, Thomas F.O'Connell wrote:

> Is there another way to accomplish what the former is doing, then?

The only thing I can think of is a subselect in from that uses distinct.
select count(*) from (select distinct ...) foo

That also theoretically allows you to use select distinct * inside the
subselect.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-11-16 23:02:56 Re: Counting Distinct Records
Previous Message Andrew Sullivan 2004-11-16 22:09:37 Re: Move table between schemas