1 select b.Id, c.* from (select ROW_NUMBER() over (partition by Id order by CreateTImedesc) rownum ,* from table1) c where c.rownum =1