立即学习: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);