EXISTS
用于检查子查询有没有数据返回,子查询有数据返回True,否则返回False
1.准备两张表
2.子查询有返回数据
select * from test_one a where test_number=202401251053
and exists(
select * from test_two where remark='0' );
3.子查询没有数据返回
select * from test_one a where test_number=202401251053
and exists(
select * from test_two where remark='1' );