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 )
This is Prashant Rathod. I am a software professional. Working on Microsoft technology specifically .Net and its components. I would like to explore new technical stuff like to work on challanging assinment.
Currently I am at Baltimore-MD U.S.A.
I did my post graduation in Computer Science from India.
No comments:
Post a Comment