tag:blogger.com,1999:blog-7955003209126272036.post8350589228829534681..comments2024-02-23T23:16:22.861+05:30Comments on Geek Explains: Java, J2EE, Oracle, Puzzles, and Problem Solving!: SQL Query to remove duplicate records from a table?Geekhttp://www.blogger.com/profile/00648920090539126396noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7955003209126272036.post-28175387947642971862011-09-15T18:07:23.727+05:302011-09-15T18:07:23.727+05:30the following link provides more information on di...the following link provides more information on different methods of deleting duplicate records<br /><br />http://www.besttechtools.com/SQLArticles.aspx?ID=DeleteDuplicateAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7955003209126272036.post-4067734376417155142010-08-17T07:36:57.269+05:302010-08-17T07:36:57.269+05:30delete from Student where rowid not in (select min...delete from Student where rowid not in (select min(rowid) from Student group by name)<br /><br />--The above sql deletes all duplicate records with same name in a Student table.Anonymousnoreply@blogger.com