Re: [sqlite] Finding duplicate records

[D. Richard Hipp]

On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen wrote:
> Hello all,
> 
> I'm new to SQL, and SQLite, and I find myself needing to
> identify duplicate records in a SQLite table (there are
> about 2K duplicates in a 36K row table).  Any suggestions
> or magic SQL queries appreciated :-)
> 

SELECT * FROM table EXCEPT SELECT DISTINCT * FROM table;