IBM Mainframe Forum

Hi All,

I want to delete duplicates records from a table, suppose 4 records are duplicate then out of 4 3 we have to delete, can anyone give me that Query???

Hello and welcome to the forum,

One way would be to unload the table (thereby creating a backup in case there are problems), remove the duplicates in batch using your sort product, then reload the non-duplicates back into the table.

You would also need to provide a clear definition of what constitutes a duplicate.

U can use" DISTINCT" to remove duplicacy

Hello,

U can use" DISTINCT" to remove duplicacy

Please post the query that will delete duplicates from a table using distinct. . .

Hi Pooja,

Distinct is not going to update any thing, it only shows the non duplicate records without updating the table.