select id,
MAX(CID) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) cid,
MAX(ORDER) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) order
from T
group by id
MAX(CID) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) cid,
MAX(ORDER) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) order
from T
group by id
select id,
MAX(CID) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) cid,
MAX(ORDER) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) order,
MAX(字段1) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) 字段1,
MAX(字段2) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) 字段2,
MAX(字段3) KEEP(DENSE_RANK LAST ORDER BY ORDER,CID,ROWID) 字段3
……
from T
group by id