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
解决方案 »
- 求一个工具
- oracle8i
- 差一个条件,执行速度相差10倍,请教?left join用法是否存在问题?
- oracle sql 实现99乘法表
- load data ???
- 表空间有剩余空间,但表插入不了记录,显示错误超出表空间限量??急!急!急!急!
- 如何动态知道表空间的大小 ~
- Oracle 存储报错,紧急求教!
- 关于Oracle中的Binar_integer和PLS_integer的几个疑问。
- (本人小白)请教,设置了SGA、PGA,以后进程总是报内存错误!
- PHP和oracle数据库连接后,用户名和密码无效是咋回事?能正常登录sql\PLUS呀
- 表中存储的表名,根据查询出的表名查询对应的数据。
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