select tid,opst from
(select tid,opst,rank() over(partition by sqid order by recordtime desc) rk
from s ) t where rk=1;
(select tid,opst,rank() over(partition by sqid order by recordtime desc) rk
from s ) t where rk=1;
解决方案 »
- 利用occi连接数据库,运行时找不到oraocci10.dll的问题
- oracle子查询的一道笔试题目,大家帮搞下,谢谢了!
- 各位好:关于oracle的一段代码为什么不输出的问题?
- 求助关于Oracle存储过程变量的问题
- 各位大侠,请问一个登陆oracle的问题,谢谢各位了
- 帮一个朋友维护网站,oracle运行半小时就自动锁死,用top发现是其狂吃内存,直到吃完为止。
- oracle9i安装问题?
- 请教触发器的问题
- 在线等待,当场解决当场给分,一个oem 中的 DBA studio 问题!!!
- 9i整个数据库导出时,作业报告失败(在线等)
- oracle 如何在事务中锁定表,其他用户不能读?
- 一个PL/SQL的问题--为什么我定义的CUR1%ROWTYPE型变量一引用就出错呢(祥见代码)
from s,
(select sqid,max(recordtime) recordtime
from s
group by sqid) t1
where s.sqid = t1.sqid
and s.recordtime = t1.recordtime
from s a
where a.sqid = '1155' and
a.recordtime = (select b.max(recordtime)
from s b
where a.sqid = b.sqid) ;
from s a
where a.sqid = '1155' and
a.recordtime = (select max(recordtime)
from s b
where a.sqid = b.sqid) 2、select *
from s,
(select sqid,max(recordtime) recordtime
from s
group by sqid) t1
where s.sqid = t1.sqid
and s.recordtime = t1.recordtime
select distinct tid,sqid,
first_value(opst) over(partition by sqid order by recordtime desc) opst,
first_value(recordtime) over (partition by sqid order by recordtime desc) record_time
from tbl;
select tid,opst from
(select tid,opst,rank() over(partition by sqid order by recordtime desc) aa
from s ) t where aa=1;
(select tid,opst,rank() over(partition by sqid order by recordtime desc) aa
from s ) t where aa=1;
from mytable x
where recordtime in (select max (recordtime)
from mytable
where sqid = x.sqid)
and sqid = 1155;