People,
On Wed, 2008-03-05 at 20:56 -0700, Kevin Kempter wrote:
> On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:
> > I was wondering if anyone knows of any good ER Diagram tools for
> > Postgres that run on Linux.
> >
> > I have been using DBDesigner by FabForce for a couple of years,
Phil,
> Each of columns that you specify in your SELECT clause, must also
> appear in the GROPU BY clause.
>
> SELECT COUNT(*) AS cnt, name, comment, ...
> FROM tst
> GROUP BY name, comment, ...
> HAVING COUNT(*) = 1;
>
>
> Phil Rhoades wrote:
> > People,
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:
nam
Guys,
On Sun, 2008-01-27 at 17:38 +0100, Pavel Stehule wrote:
> On 27/01/2008, Phil Rhoades <[EMAIL PROTECTED]> wrote:
> > Tino,
> >
> >
> > On Sun, 2008-01-27 at 15:16 +0100, Tino Wildenhain wrote:
> > > Phil Rhoades wrote:
> > > > Peop
Tino,
On Sun, 2008-01-27 at 15:16 +0100, Tino Wildenhain wrote:
> Phil Rhoades wrote:
> > People,
> >
> > I want to select from a table ONLY unique records ie if a column has
> > values:
> >
> > 1
> > 2
> > 3
> > 3
> > 4
> >
Pavel,
You didn't read my note properly - your query gives:
1
2
3
4
5
I want:
1
2
4
5
Phil.
On Sun, 2008-01-27 at 15:10 +0100, Pavel Stehule wrote:
> Hello
>
> try
>
> SELECT DISTINCT col FROM table
>
> Pavel
>
> On 27/01/2008, Phil Rhoades <[
People,
I want to select from a table ONLY unique records ie if a column has
values:
1
2
3
3
4
5
I want ONLY these records returned:
1
2
4
5
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)