题解 | #查找学校是北大的学生信息#
Where in 和Not in
http://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
SELECT device_id, gender, age, university, gpa
FROM user_profile
WHERE university IN('北京大学', '复旦大学', '山东大学');
Where in 和Not in
http://www.nowcoder.com/practice/0355033fc2244cdaa09b2bd6e794c762
SELECT device_id, gender, age, university, gpa
FROM user_profile
WHERE university IN('北京大学', '复旦大学', '山东大学');
相关推荐