Oracle SQL distinct on single column select * from TABLE_NAME where rowid in ( select max(ROWID) from TABLE_NAME GROUP BY COLUMN_NAME );