17,382
社区成员




SELECT a.*
FROM (SELECT 1 deptno,
'开发部' bumen
FROM dual
UNION
SELECT 2 deptno,
'销售部' bumen
FROM dual
UNION
SELECT 6 deptno,
'技术部' bumen
FROM dual
UNION
SELECT 4 deptno,
'事业部' bumen
FROM dual
UNION
SELECT 5 deptno,
'人事部' bumen
FROM dual
UNION
SELECT 3 deptno,
'行政部' bumen
FROM dual) a
ORDER BY decode(bumen, '人事部', 1, '技术部', 2, '行政部', 3, '销售部', 4, '开发部', 5, '事业部', 6)