select t2.* from (select device_id,gender,age,university,gpa from user_profile where university like '山%' and gpa >3.5 union all select device_id,gender,age,university,gpa from user_profile where university like '复%' and gpa >3.8) as t2 order by t2.gpa asc; 这么写理论上应该没有问题,而且应该比多个条件复用快,不知道...