通过的代码
1 2 3 4 5 6 7 |
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'
|
过程
一开始是这样的1 2 3 |
select device_id, gender, age, gpa
from user_profile
where university = '山东大学' or gender = 'male' ;
|
1 2 3 4 5 6 7 |
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'
|