sql里,where a in (select .) and b in (select .)这种表示合法吗?
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/08/06 20:13:43
sql里,where a in (select .) and b in (select .)这种表示合法吗?
![sql里,where a in (select .) and b in (select .)这种表示合法吗?](/uploads/image/z/16490616-24-6.jpg?t=sql%E9%87%8C%2Cwhere+a+in+%28select+.%29+and+b+in+%28select+.%29%E8%BF%99%E7%A7%8D%E8%A1%A8%E7%A4%BA%E5%90%88%E6%B3%95%E5%90%97%3F)
写法合法的,并且经常这样用
select ** from A where A.id in (select id from B where ****)
SQL语句理解 select * from B where (select count(1) as num from A
ms sql :select * from (select *from b) as xxx where 和 select
delete from A where a_id in (select id from B where b_id in
请问大侠,我要在function()下写一个动态sql语句,如select * from A WHERE name in
select * from order where clientNo in (select distinct(clien
SELECT student_id FROM tuition where student_id in ( SELECT
select * from teacher where s_id in(select s_id from student
select * from user_info where user_name in (select user_name
SQL >select count(*) from Teacher where teacherCode=? and te
String sql = "select * from tb_consumer where account='" + a
select A,B,C,D=(select count(*) from 表 where c=a.a and b=a.b