Skip site navigation (1) Skip section navigation (2)

Re: SELECT syntax question - combining COUNT and DISTINCT

From: zmilos(at)sympatico(dot)ca (zhix)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: SELECT syntax question - combining COUNT and DISTINCT
Date: 2003-10-07 02:51:51
Message-ID: c59f4459.0310061851.6d5f9e1a@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-novice
This should do:

select pdb_id,count(*) 
from   chain 
where  chain_id = 'A' 
group by pdb_id;

rgds,
zhix

In response to

pgsql-novice by date

Next:From: Joe ConwayDate: 2003-10-07 04:17:39
Subject: Re: Getting "connectby" installed
Previous:From: zhixDate: 2003-10-07 00:38:25
Subject: Re: SELECT syntax question - combining COUNT and DISTINCT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group