select device_id,gender,age_cut from ( select id,device_id,gender,'20岁以下' age_cut from user_profile where age < 20 union select id,device_id,gender,'20-24岁'age_cut from user_profile where age >= 20 and age <= 24 union select id,device_id,gender,'25岁及以上' age_cut from user_profile where age >= 25 union select id,device_id,gender,'其他' age_cut from user_profile where age is null order by id) temp1;