题解 | #Where in 和Not in#
Where in 和Not in
http://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
SELECT device_id,gender,age,university,gpa
from user_profile
where university in (SELECT university
from user_profile
where university="北京大学" or university="复旦大学"
or university="山东大学");
三环集团开奖124人在聊