Thread: Find duplicate entries in a table?
View Single Post
  #7 (permalink)  
Old 04-01-2008, 07:30 AM
Unregistered
 
Posts: n/a
Lightbulb ANY answer. Re: Find duplicate entries in a table?
[sql]select t1.field_name from tablename t1, tablename t2 where t1.field_name=t2.field_name and t1.rowid <> t2.rowid;[/sql]
Reply With Quote