17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select name
2 from a
3 where id in (select id from b order by id);
where id in (select id from b order by id)
*
第 3 行出现错误:
ORA-00907: 缺失右括号
SQL> select name
2 from a
3 where id in (select id from b);
NAME
----------------------------------------
wp
wh
select id from docomexam where sysuserid = 4 order by id desc
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))
WHERE ROWNUM <= 10);