Use SQL to delete duplicate records

This short command will delete duplicate keys in SQL.

Maybe you found a mistake in your application and impacted to the duplicate key found in file that you don't need. Now what? Here is a short command in SQL that will delete duplicate keys. In this example, FILEA = File name, LIBA=Library name, and INVNO=key field.

DELETE FROM LIBA/FILEA F1 WHERE RRN(F1) > (select MIN(RRN(F2)) FROM FILEA F2 WHERE F2.INVNO=F1.INVNO)

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your programming questions--or help out your peers by answering them--in our live discussion forums.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.


This was first published in December 2003

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close