how to delete duplicate row from table?

Question

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

Answer 1

using distinct keyword u take only unique IDs

Answer 2

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

Answer 3

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 .

Answer 4

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....

Answer 5

use rowid for deletion of duplicate row

Answer 6

first alter to add use identity then use delete method this is possible I work out it

Answer 7

To remove duplicate items from a list, you can simply use a tool or method that filters out repeated entries. For example, in Excel, select your list, go to the Data tab, and click Remove Duplicates. If you're dealing with Outlook items like emails or contacts, a tool like SysTools Outlook Duplicate Remover can help you automatically find and delete duplicates from PST or OST files in just a few clicks.
follow here: https://www.systoolsgroup.com/outlook-duplicates-remover.html

Answer 8

use delete from then select which table(Id) you want to delete.