Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Identify Duplicated Records For Primary Key Fields

Does anyone has codes for identifying duplicate records for the primary key in my database table? For an example now i have 2 primary key in my database table.

I need dynamic codes so i can applied it for different tables.

1) How do i check the data in a column if there are duplicate?

( 1 primary key )

<b>Admino</b>

051111

052222

051111

2) How do i check the data of two or more column to see if they are duplicate?

( this means that there are 2 or more primary key )

<b>Admino</b>

<b>Name</b>

051111

John

052222

Mary

051111

John

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question