单表查询:一张用户表,罗列出男女性别并排序
面试中碰到的问题
表为一张用户表:itsm_sys_user
字段:usersex
select
usersex
from
(
select usersex from itsm_sys_user where usersex = '男' union all
select usersex from itsm_sys_user where usersex = '女'
)aa order by usersex desc
单表查询:一张用户表,罗列出男女性别并排序
面试中碰到的问题
表为一张用户表:itsm_sys_user
字段:usersex
select
usersex
from
(
select usersex from itsm_sys_user where usersex = '男' union all
select usersex from itsm_sys_user where usersex = '女'
)aa order by usersex desc