Re: [sqlite] A beginner SQL question

On 05/11/2007, A.J.Millan <[EMAIL PROTECTED]> wrote: > I All: > > 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 ther

[sqlite] A beginner SQL question

I All: 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 sa