How to remove the duplicates rows from a DB2 Table

Shaikshavali · New User Joined: 18 Jun 2005 Posts: 22 Location: chennai

HOW TO RETRIEVE DUPLICATE ROWS FRROM A PARTICULAR TABLE

Shaikshavali · New User Joined: 18 Jun 2005 Posts: 22 Location: chennai

HOW TO REMOVE(NOT ELEMINATING) DUPLICATES FROM A TABLE USING SINGLE QUERY

jagadish2005 · New User Joined: 08 Mar 2005 Posts: 20

Hi,

try this query

Select * from tablename group by columnname having count(columnname) > 1

with regards
Arunachalla

bimalpattanayak · New User Joined: 08 Apr 2005 Posts: 3

select distinct (*) form tablenamewill solve your prob

karthi_ind · Posted: Fri Sep 30, 2005 5:03 pm

Hi Shaikshavali

By using a single query we cant eliminate duplicate rows i thnk

But u can use this subquery to delete duplicate rows

delete from table name where
salary in
(select salary from tablename
group by salary having count(*) > 1)

I thnk it vll work. but it vll delete all duplicate rows.
Corrections are welcome..

Karthi G.