how to delete duplicate row from table?

if table having same record then how to delete one of them

12th Aug 2016, 7:02 AM
Dnyaneshwar Godge
7 Answers
+ 5
using distinct keyword u take only unique IDs
13th Aug 2016, 4:15 PM
Vijay Bharati
Vijay Bharati - avatar
+ 3
insert values into other new table by SELECT DISTINCT * FROM TABLE1 INTO newtable then DELETE FROM TABLE1 then again insert dem back onto table1 from Newtable in similar fashion
14th Aug 2016, 4:13 PM
ravi kumar K N
+ 1
by using distinct keyword we can do ......and another procedure also there like first we need to find out the duplicate records and then we need to remove them with the help of rownum .
14th Aug 2016, 7:37 PM
mathaiah thirupathi
+ 1
delete from tbl1 a where rowid not in(select max(rowid) from tbl1 b where a.col1 = b.col1)---here col1 is the duplicate column....
18th Aug 2016, 9:50 AM
use rowid for deletion of duplicate row
21st Sep 2016, 5:25 PM
Shrey Saxena
Shrey Saxena - avatar
first alter to add use identity then use delete method this is possible I work out it
11th Oct 2016, 2:36 PM
- 4
use delete from then select which table(Id) you want to delete.
12th Aug 2016, 5:28 PM
Faisal Mohiuddin
Faisal Mohiuddin - avatar