Showing posts with label Remove duplicate record. Show all posts
Showing posts with label Remove duplicate record. Show all posts

Saturday, September 13, 2008

Query to remove duplicate record from the table - Oracle

SELECT a.Employee_No,a.Employee_Name
FROM Employee_Contact a
where rowid >
(select min(rowid) from Employee_Contact b
where a.Employee_No = b.Employee_No
)