Igor Tandetnik wrote: > > flakpit <[EMAIL PROTECTED]> wrote: >> Is there a way of querying the database to list all duplicate entries >> from a column in the same table? >> >> Something like "SELECT * FROM mytable WHERE last NOT UNIQUE" > > select * from mytable t1 where exists ( > select * from mytable t2 where t1.last=t2.last and t1.rowid != > t2.rowid); > > -- or > > select * from mytable where rowid not in ( > select rowid from mytable > group by last > having count(*) = 1 > ); > > Igor Tandetnik > >
Thank you!!! I will have fun trying this out. -- View this message in context: http://www.nabble.com/Listing-duplicate-entries-tp16941525p16951811.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users