22,300
社区成员




SELECT *
FROM ( SELECT DISTINCT
mc
FROM tkh
) T
ORDER BY ( CASE mc
WHEN '董事长' THEN 1
WHEN '副董' THEN 2
WHEN '经理' THEN 3
WHEN '副经理' THEN 4
END )
select mc
from tkh
group by mc
order by
(CASE mc WHEN '董事长' THEN 1 WHEN '副董' THEN 2 WHEN '经理' THEN 3 WHEN '副经理' THEN 4 end)
--更正
select mc
from tkh
group by mc
order by
(CASE mc WHEN '董事长' THEN 1 WHEN '副董' THEN 2 WHEN '经理' THEN 3 WHEN '副经理' THEN 4 end)
select * from
(select distinct mc from tkh) t
order by (select CASE mc WHEN '董事长' THEN 1 WHEN '副董' THEN 2 WHEN '经理' THEN 3 WHEN '副经理' THEN 4 end)
select distinct mc from tkh
order by
(CASE mc WHEN '董事长' THEN 1 WHEN '副董' THEN 2 WHEN '经理' THEN 3 WHEN '副经理' THEN 4 end)