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
Oracle 分组排序后取第一条数据
最新推荐文章于 2024-08-17 18:47:54 发布