ORACLE指定排序的方法

SELECT '2' AS "LAST",
	   T.SCHE_ID,
	   T.SCHE_MODE,
       T.GWID AS "GWID",
       T.GWNAME AS "SHORTNAME",
       NVL(SUM(T.SGRS),0) AS "YQSGNUM",
       (SELECT NVL(SUM(H.SGRS),0) FROM VPOST_GWBSXXH H WHERE H.SGRQ =TO_CHAR(SYSDATE,'YYYY-MM-DD') AND H.GWBH = T.GWID AND T.SCHE_ID = H.SCHE_ID) AS "SJSGNUM"
  FROM VPOST_SCHE_BSXX T WHERE (SYSDATE BETWEEN T.SCHE_QSSJ AND T.SCHE_JSSJ) 
   AND T.DDDM = #{dept,jdbcType=VARCHAR} 
GROUP BY T.GWNAME,T.GWID,T.SCHE_ID,T.SCHE_MODE 
ORDER BY DECODE(T.SCHE_MODE,'02',1)

代码是想让模式为02的 数据排在前面，那么就可以用 ORDER BY DECODE (T.SCHE_MODE,'02',1)指定让他排在第一位

#{dept,jdbcType=VARCHAR} 是mybatis的参数