帮忙看一下我的sql语句错在哪了

select id,uname from sysusers a,
(select distinct sysuser_id from docomman a,docomexam b where a.docomexam_id = b.id and sysuserid = 4 order by id desc ) b
where a.id=b.sysuser_id and rownum <=10 ;

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
这样就好了吧。

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 desc ))
where rownum <=10 );
你试试。

去掉order by id desc ，在它后加个），去掉where rownum <=10 ); 应该就OK了