Re: a change of query - Mailing list pgsql-sql

From Rod Taylor
Subject Re: a change of query
Date
Msg-id 1046213403.32353.50.camel@jester
Whole thread Raw
In response to a change of query  ("James Cooper" <jim@luckydigital.com>)
List pgsql-sql
On Tue, 2003-02-25 at 17:03, James Cooper wrote:
> select distinct cp.person_id from cluster_person cp, cluster c where
> cp.cluster_id = c.cluster_id and c.c_id = 1
>
> can this query be changed to give just the row count?( of the distinct
> rows )

:) So close

select count(distinct cp.person_id) from...

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-sql by date:

Previous
From: Brad Hilton
Date:
Subject: Re: a change of query
Next
From: "Chad Thompson"
Date:
Subject: Re: a change of query