Oracle gets the latest version of the data

Table data such as: In code as the version of the Group field, the creation time to sort by the latest

ID NAME CODE Create_time

1FFG ABC 001 2014-01-01

1GFFD KABC 001 2014-01-02

1HFD LABC 001 2014-01-03

1GHD ABC 002 2014-01-01

1FHD KABC 002 2014-01-06

1FFD LABC 002 2014-01-03

SELECT *  from ( SelectId,name,code,create_timerow_number () Over(PARTITION byCODEORDER  byCreate_timeDESC) asRN fromsys_oa_form T)WHERERn= 1  andId!='0'

The results are as follows

1HFD LABC 001 2014-01-03

1FHD KABC 002 2014-01-06

Oracle gets the latest version of the data