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