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 使用联合查询后将查询的结果视为一个新的表再对这个表进行一次查询后再来一次倒序