sql排序null在最后

sql排序null在最后

 

SELECT *
  FROM T_RPT_BUSINESS_STRUCTURE T
 WHERE T.JYS_ID = 11
 ORDER BY DECODE(T.BUSS_TYPE_ID, '-1', NULL, T.BUSS_TYPE_ID),
          DECODE(T.TRADE_VARIETY_ID, '-1', NULL, T.TRADE_VARIETY_ID),
          DECODE(T.TRADE_SUBVARIETY_ID, '-1', NULL, T.TRADE_SUBVARIETY_ID),
          DECODE(T.TRADE_CODE, '-1', NULL, T.TRADE_CODE) NULLS LAST