我有一个oracle查询,我希望结果是自定义的“高级主管”,“董事”,“经理”,“雇员”,来自GRADE_DESCRIPTON领域.我正在使用以下查询.
但是我没有得到理想的结果
结果的顺序是“高级主管”,董事,“员工”
SELECT DISTINCT GRADE_DESCRIPTION,HIRING_FORECATS.*
FROM GRADE_MASTER left join HIRING_FORECATS
ON (HIRING_FORECATS.GRADE = GRADE_MASTER.GRADE_DESCRIPTION
and HIRING_FORECATS.LOCATION = 'HO' )
order by decode
(GRADE_MASTER.GRADE_DESCRIPTION,'SENIOR DIRECTOR','DIRECTOR','MANAGER','EMPLOYEE')
有什么建议么？？
ORDER BY DECODE(
GRADE_MASTER.GRADE_DESCRIPTION,1,2,3,'EMPLOYEE',4,5)
