From: | Phil Rhoades <phil(at)pricom(dot)com(dot)au> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: A select DISTINCT query? - followup Q |
Date: | 2008-01-27 17:33:12 |
Message-ID: | 1201455192.28880.105.camel@prix.pricom.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
People,
> select count(*) as cnt, name from tst group by name having count(*) = 1
This worked for my basic example but not for my actual problem - I get
"column comment must appear in the GROUP BY clause or be used in an
aggregate function" errors so I have a related question:
With table:
name comment
1 first comment
2 second comment
3 third comment
3 fourth comment
4 fifth comment
5 sixth comment
- how can I use something like the previous select statement but where
the comment field does not appear in the "group by" clause and gives the
following result:
1 first comment
2 second comment
4 fifth comment
5 sixth comment
Thanks,
Phil.
--
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Fax: +61:(0)2-8221-9599
E-mail: phil(at)pricom(dot)com(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-27 17:56:49 | Re: Very long execution time of "select nextval('..');" |
Previous Message | Phil Rhoades | 2008-01-27 16:41:12 | Re: A select DISTINCT query? |