order by 在你这条语句里 好像没啥大的作用似的的吧。
select id,uname from sysusers where id in
(select sysuser_id from
(select distinct sysuser_id from docomman where docomexam_id in(select id from docomexam where sysuserid = 4 order by id desc ))) and rownum <=10
这样就好了吧。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024