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, but
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:
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 [EMAIL PROTECTED] wrote:
People,
I want to select
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
5
I want ONLY these records returned:
1
2
4
5
SELECT count(*) as cnt
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:
People,
I want to select from a table ONLY unique records ie if a column
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
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,
select count(*) as cnt, name from tst group by name having