SELECT *
FROM T1 a
WHERE ROWID >=
(
SELECT MIN(ROWID)
FROM T1 b
WHERE a.c1 = b.c1
AND a.c2 = b.c2
AND a.c3 = b.c3
);
"Doron" <doron_almog_at_msn.com> wrote in message
news:995517bc.0308181152.209df81e_at_posting.google.com...
> Hi,
> I want to create a unique validated constraint on three columns of a
> very large existing table. the create is failing due to the validation
> process.
>
> anybody got any SQL code that will help me determine in which rows the
> data appears more then once?
>
> thanks,
> Doron
Received on Mon Aug 18 2003 - 17:21:49 CDT
