SQL union all和union

1 union all

union all表示不剔除重复记录，

例如：

select device_id, gender, age, gpa from user_profile where university = '山东大学'
union all
select device_id, gender, age, gpa from user_profile where gender = 'male';

2 union

union表示剔除重复记录，
例如：

select device_id, gender, age, gpa from user_profile where university = '山东大学'
union
select device_id, gender, age, gpa from user_profile where gender = 'male';

上述语句查找学校是山东大学或性别为男的记录，相当于

select device_id, gender, age, gpa from user_profile where university = '山东大学' or gender = 'male';