功能:将管理员排在最前面
select t.姓名 from meta_upc_userextention t order by (case (select rolecode from meta_upc_user_role ur where ur.usercode=t.姓名)when 'admin' then 'admin' else 'other' end);
select t.姓名 from meta_upc_userextention t order by (case (select rolecode from meta_upc_user_role ur where ur.usercode=t.姓名)when 'admin' then 'admin' else 'other' end);