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