方法:row_number() over(partition by 分组条件列名 order by 排序条件列名) 别名
-
例子:
表名:tableTest
列:- TASK_NO 合同号
- START_TIME 启动时间
目的:查询某个合同下启动时间最新的那条数据
//通过rownum有时候结果会有误
select * from tableTest
order by START_TIME desc
where TASK_NO =''
and rownum = 1
建议使用:
select * from
(select * ,
row_number() over(partition by TASK_NO order by START_TIME desc) rn
from tableTest)
where rn = 1