查询学号是S_1001,S_1002,S_1003的记录
select * from stu where sid in(‘S_1001‘,‘S_1002‘,‘S_1003‘);
查询学号不是S_1001,S_1002,S_1003的记录
select * from stu where sid not in(‘S_1001‘,‘S_1002‘,‘S_1003‘);
2021-10-20 12:18:23
查询学号是S_1001,S_1002,S_1003的记录
select * from stu where sid in(‘S_1001‘,‘S_1002‘,‘S_1003‘);
查询学号不是S_1001,S_1002,S_1003的记录
select * from stu where sid not in(‘S_1001‘,‘S_1002‘,‘S_1003‘);