Re: [GENERAL] Selecting duplicates

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Mike Mascari <mascarim(at)yahoo(dot)com>
Cc: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Selecting duplicates
Date: 1999-08-06 08:15:31
Message-ID: 37AA99A3.C37EB3F1@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

vac=> create table t (x int);
CREATE
vac=> insert into t values (1);
INSERT 18579 1
vac=> insert into t values (1);
INSERT 18580 1
vac=> insert into t values (2);
INSERT 18581 1
vac=> select x from t group by x having count(*) > 1;
x
-
1
(1 row)

Vadim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 1999-08-06 08:19:24 Re: [GENERAL] Selecting duplicates
Previous Message Mike Mascari 1999-08-06 08:06:37 Re: [GENERAL] Selecting duplicates