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