Re: SELECT syntax question - combining COUNT and DISTINCT - Mailing list pgsql-novice

This should do:

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

rgds,
zhix