SQL> select id, to_char(cnt,'fm000000009') || link data
  2    from t
  3  /

   ID 	 DATA

----- 	 -----------
40032 	 00000000132
40033 	 00000000143
40034 	 00000000616
40034 	 00000000622
40034 	 00000000228


SQL> select id, max( to_char(cnt,'fm000000009') || link ) data
  2    from t
  3   group by id
  4  /

   ID	 DATA

----- 	 -----------
40032	 00000000132
40033	 00000000143
40034	 00000000622