Igor:
The proposed solution seem list all rows in the table. Perhaps miss some
thing in between myTable t1 and myTable t2?
Gerry:
Yours solution does not list any at all. It is likely that there are not
duplicated entrys (at least must not happen that.).
Thanks for yours input.
A.J.Millan
A.J.Millan <> wrote:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files
and/or
who are they?
Consider duplicate file if there are two or more rows with the same
values.
I.E:
two or more with same values A=X, B=Y, C=Z
or
A= X, B=Y, C=NULL
for any 3-tuple X Y Z
select t1.A, t1.B, t1.C
from myTable t1, myTable t2
where t1.A = t2.A and t1.B = t2.B and
(t1.C = t2.C or (t1.C is null and t2.C is null));
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------