大家也可以试试用exists来写写,功能实现是一样的,具体可以看下面代码!!!! SELECT device_id,gender,age,university FROM user_profile u1 WHERE NOT EXISTS (SELECT id FROM user_profile u2 WHERE u1.id = u2.id AND u2.university = "复旦大学");