Oracle 分组排序后取第一条数据
select * from (
select t., row_number() over (partition by user_sid order by sid desc) rn ,count() over (partition by user_sid) nums from sys_user_rel t
where user_sid in (select sid from sys_user where user_state = ‘LOCKED’) ) where rn=1
原创
2021-04-14 14:21:56 ·
1010 阅读 ·
0 评论