SQL 想把nickname字段归属一下，比如是超级管理员的 nickname就是小李和小猪

变成如下的格式

select nickname from table group by nickname

select distinct nickname,roleName from table where roleName in (select distinct rolaName from table ) order by roleName

如果有报错的话就把order by去掉试试。