题解 | #Where in 和Not in#
Where in 和Not in
https://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
select device_id,gender,age,university,gpa from user_profile where university in ("北京大学","复旦大学","山东大学");
字段 in("字段一","字段二","字段三") : in 关键字,查看字端是否在提供的范围内,对应的是not in