select device_id,gender,"20岁以下" as age_cut from user_profile where age<20 union all select device_id,gender,"其他" as age_cut from user_profile where age is null union all select device_id,gender,"20-24岁" as age_cut from user_profile where age<=24 and age>=20 union all select device_id,gender,"25岁及以上" as age_cut from user_profile where age>=25 我用联合查询语句,但是顺序就是很难弄对 ,有高手指点一下吗?
点赞

相关推荐

点赞 评论 收藏
分享
牛客网
牛客企业服务