LISTING 4:Encoding aggregate and related information

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