立即学习:https://edu.csdn.net/course/play/27328/370702?utm_source=blogtoedu
where子句使用in语法
select column_name from table_name where column_name IN(value1,vaule2,...)
子查询in语法
select column_name from table_name where column_name IN(select column_name from table_name where condition)
where子句使用exists语法
select column_name1 from table_name1 where exists(select * from table_name2 where condition);