题解 | #操作符混合运用#
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
#1 and or 最快36ms #2 union all 37ms #3 in 45ms select device_id, gender, age, university, gpa from user_profile where id in ( select case when gpa > 3.5 and university = '山东大学' then id when gpa > 3.8 and university = '复旦大学' then id else -1 end from user_profile)