TechInfoBI
Informatica , MSBI Topics,OBIEE
Thursday, 25 October 2012
Removing duplicate records by using Oracle's ROWID
Select col1,col2,col3,col4 from TableName where ROWID in (select max(ROWID) from TableName group by col1,col2)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment