题解 | #操作符混合运用#
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa from user_profile where (gpa>3.5 and university in ('山东大学') ) or (gpa>3.8 and university in ('复旦大学'))
写的复杂了些,不过可以用
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa from user_profile where (gpa>3.5 and university in ('山东大学') ) or (gpa>3.8 and university in ('复旦大学'))
写的复杂了些,不过可以用
相关推荐