select clum1,clum2 from table1 a, (select max(rowid) no from table1 group by clum1) b where a.rowid=b.no