Igor Tandetnik
> select rowid, A, B, C
> from t
> where A||B||C in
> ( select A||B||C
> from t
> group by A, B, C
> having count(*)>1
> );
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
Due the fact that, in this case, the co
duplicate record is considered as f1=f1 AND f2=f2
AND f3=f3 would be:
select f1, f2, f3 from t1 group by f1, f2, f3 having count(*) > 1
This query could probably be expanded to show the rowid of each
offending record (through either a join or a union perhaps?), but at the
moment I can
On 05/11/2007, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Simon Davies
> wrote:
> > I use:
> >
> > select rowid, A, B, C
> > from t
> > where A||B||C in
> > ( select A||B||C
> > from t
> > group by A, B, C
> > having count(*)>1
> > );
>
> Wouldn't that mistakenly consider a record ('xy', 'z', 'w'
Simon Davies
wrote:
I use:
select rowid, A, B, C
from t
where A||B||C in
( select A||B||C
from t
group by A, B, C
having count(*)>1
);
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
--
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.Mill
Igor Tandetnik wrote:
A.J.Millan <[EMAIL PROTECTED]> 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 ro
A.J.Millan <[EMAIL PROTECTED]> 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
valu
7 matches
Mail list logo