题解 | #操作符混合运用#
操作符混合运用
http://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
外部使用or,内部使用and
SELECT device_id,gender,age,university,gpa FROM user_profile WHERE (gpa > 3.5 and university = "山东大学") OR (gpa > 3.8 and university = "复旦大学")
操作符混合运用
http://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa FROM user_profile WHERE (gpa > 3.5 and university = "山东大学") OR (gpa > 3.8 and university = "复旦大学")
相关推荐