题解 | #操作符混合运用#
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
select * from (SELECT device_id, gender, age, university,gpa from user_profile where gpa > 3.8 and university = '复旦大学' UNION SELECT device_id, gender, age, university,gpa from user_profile where gpa > 3.5 and university = '山东大学') as t order by device_id
使用联合查询后将查询的结果视为一个新的表再对这个表进行一次查询后再来一次倒序
查看5道真题和解析
