17,382
社区成员




select *
from (select tmp.*,rownum row_id
from (select t.*
from (select * from sys_user where username like 'username' and userMgrType <> 10 and deleted = 2 ) t
join sys_department deptObj on t.dept = deptObj.id
where (deptObj.path like '部门path')
order by t.ordernum asc) tmp
where rownum <= 10 )
where row_id > 0;
select *
from (select tmp.*,rownum row_id
from (select t.*
from (select * from sys_user where t.username like 'username' and t.userMgrType <> 10 and t.deleted = 2 ) t
join sys_department deptObj on t.dept = deptObj.id
where (deptObj.path like '部门path')
order by t.ordernum asc) tmp
where rownum <= 10 )
where row_id > 0;