17,377
社区成员
发帖
与我相关
我的任务
分享
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
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