select max(t.yylcbh)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as yylcbh,
t.ch as ch,
max(t.lc)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as lc,
max(t.tjsj)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as tjsj ,
max(t.bz)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as bz
from yylc t group by t.ch
t.ch as ch,
max(t.lc)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as lc,
max(t.tjsj)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as tjsj ,
max(t.bz)KEEP (dense_rank FIRST ORDER BY t.tjsj desc) as bz
from yylc t group by t.ch