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
)

No comments: