DELETE FROM table_name a WHERE ROWID >(SELECT min(ROWID)

How To delete duplicate record from a particular table?

Question Posted / manoj

Answer Posted / manoj

DELETE FROM table_name a
WHERE ROWID >(SELECT min(ROWID)
FROM table_name b
WHERE a.col_1=b.col_1 )

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are relationships and mention different types of relationships in the dbms

964

What is a partition key?

960

What do you mean by sql server agent?

999

What are logical/boolean operations in ms sql server?

1051

How to provide column names in insert statements in ms sql server?

1162

What triggers long term care?

1041

What is @@error in sql?

1072

What are different backups available in sql server?

1079

What is the difference between implicit and explicit transaction?

1021

What are the steps you must follow to hide sql server instances?

980

Do you know how to send email from database?

1012

What are the differences between char and nchar in ms sql server?

1091

What is the main purpose of having conversation group?

900

Define outer join?

1004

Explain trigger and trigger types?

988