22,207
社区成员
发帖
与我相关
我的任务
分享
select
*
from (
select 101 as Col,'一组' as Col2 union
select 102,'三组' union
select 103,'二组' union
select 104,'四组' union
select 105,'二组' union
select 106,'一组' union
select 107,'八组'
)t
order by locate(left(Col2,1),'一二三四五六七八九十') asc
with cte(id,zs) as (
select 101,'一组' union
select 102,'三组' union
select 103,'二组' union
select 104,'四组' union
select 105,'二组' union
select 106,'一组' union
select 107,'八组'
)
select * from cte order by
case zs when '一组 ' then 1
when '二组' then 2
when '三组' then 3
when '四组' then 4
when '五组' then 5
when '六组' then 6
when '七组' then 7
when '八组' then 8
when '九组' then 9 end