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
ember 05, 2007 13:19
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: A beginner SQL question
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
> > ( s
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',
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.
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
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
7 matches
Mail list logo