My SQL

1.根据字段的不同值自定义排序

SELECT [sslb],[xm],[ksfpds] ,[ksjjfp],[ssmcICD9]  FROM [JXKH_BI_WebSite].[dbo].[ks_2_ss]  where rq='201602' order by case sslb 

when '一级' then 1 
when '二级' then 2 
when '三级' then 3 
when '四级' then 4 
when '' then 5

end

2.合并同类型排序

     select  [qz] ,[hj], [cybr_jj],[DRG_mc],[brxm]  from

   (  

      select 'RM<0.5' as qz ,1 as px,[hj], [cybr_jj],[DRG_mc],[brxm] from ks_2_cybr  where qz < 0.5 and rq='-1' and jjffbm='-1'

      union  select '0.5<=RM<1' as qz,2,[hj], [cybr_jj],[DRG_mc],[brxm] from ks_2_cybr   where qz< 1 and qz>=0.5 and rq='-1' and jjffbm='-1' 
      union  select '1<=RM<1.5' as qz,3, [hj], [cybr_jj],[DRG_mc],[brxm] from ks_2_cybr  where qz< 1.5 and qz>=1 and rq='-1' and jjffbm='-1'
      union select '1.5<=RM<2' as qz,4, [hj], [cybr_jj],[DRG_mc],[brxm] from ks_2_cybr  where qz< 2 and qz>=1.5 and rq='-1' and jjffbm='-1'

      union select 'RM>=2' as qz, [hj],5, [cybr_jj],[DRG_mc],[brxm] from ks_2_cybr  where  qz>=2 and qz>1.5 and rq='-1' and jjffbm='-1'

 )  t   order by t.px