题解 | #操作符混合运用#
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa FROM user_profile where (university='山东大学' AND gpa>3.5 ) OR (university='复旦大学' AND gpa>3.8); //()进行数据合并筛选
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa FROM user_profile where (university='山东大学' AND gpa>3.5 ) OR (university='复旦大学' AND gpa>3.8); //()进行数据合并筛选
相关推荐