题解 | #查找山东大学或者性别为男生的信息#
查找山东大学或者性别为男生的信息
http://www.nowcoder.com/practice/979b1a5a16d44afaba5191b22152f64a
#学校为山东大学或性别为男：university = '山东大学' or gender = '男'
#先输出山东大学：order by university
#拼接表：union all
with a as
(select device_id,gender,age,gpa from user_profile
where university = '山东大学'),
b as
(select device_id,gender,age,gpa
from user_profile where gender = 'male')
select * from a union all select * from b
查看14道真题和解析