题解 | #Where in 和Not in#
Where in 和Not in
http://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
WHERE IN
select device_id,gender,age,university,gpa
from user_profile
where university in ('北京大学' , '复旦大学' , '山东大学');
Where in 和Not in
http://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
WHERE IN
select device_id,gender,age,university,gpa
from user_profile
where university in ('北京大学' , '复旦大学' , '山东大学');
相关推荐