SELECT T.VEHICLE_ORDER_ID,
MAX(DECODE(T.STATUS, '2015A', T.CREATE_DATE, NULL)) AS "2015A",
MAX(DECODE(T.STATUS, '2016R', T.CREATE_DATE, NULL)) AS "2016R",
MAX(DECODE(T.STATUS, '3300A', T.CREATE_DATE, NULL)) AS "3300A",
MAX(DECODE(T.STATUS, '3300Rj', T.CREATE_DATE, NULL)) AS "3300Rj",
MAX(DECODE(T.STATUS, '3300Rl', T.CREATE_DATE, NULL)) AS "3300Rl",
MAX(DECODE(T.STATUS, 'Online', T.CREATE_DATE, NULL)) AS "Online",
MAX(DECODE(T.STATUS, '3800', T.CREATE_DATE, NULL)) AS "3800",
MAX(DECODE(T.STATUS, '4000', T.CREATE_DATE, NULL)) AS "4000",
MAX(DECODE(T.STATUS, 'S2', T.CREATE_DATE, NULL)) AS "S2",
MAX(DECODE(T.STATUS, 'S3', T.CREATE_DATE, NULL)) AS "S3",
MAX(DECODE(T.STATUS, 'V2', T.CREATE_DATE, NULL)) AS "V2",
MAX(DECODE(T.STATUS, 'V4', T.CREATE_DATE, NULL)) AS "V4",
MAX(DECODE(T.STATUS, 'S5', T.CREATE_DATE, NULL)) AS "S5",
MAX(DECODE(T.STATUS, 'S6', T.CREATE_DATE, NULL)) AS "S6",
MAX(DECODE(T.STATUS, 'C', T.CREATE_DATE, NULL)) AS "Cancelled",
MAX(DECODE(T.STATUS, 'B', T.CREATE_DATE, NULL)) AS "Billed"
FROM TL_SGM_VEHICLE_ORDER_HISTORY T
WHERE T. VEHICLE_ORDER_ID = 30
GROUP BY T.STATUS, T.VEHICLE_ORDER_ID
ORDER BY T.VEHICLE_ORDER_ID;
MAX(DECODE(T.STATUS, '2015A', T.CREATE_DATE, NULL)) AS "2015A",
MAX(DECODE(T.STATUS, '2016R', T.CREATE_DATE, NULL)) AS "2016R",
MAX(DECODE(T.STATUS, '3300A', T.CREATE_DATE, NULL)) AS "3300A",
MAX(DECODE(T.STATUS, '3300Rj', T.CREATE_DATE, NULL)) AS "3300Rj",
MAX(DECODE(T.STATUS, '3300Rl', T.CREATE_DATE, NULL)) AS "3300Rl",
MAX(DECODE(T.STATUS, 'Online', T.CREATE_DATE, NULL)) AS "Online",
MAX(DECODE(T.STATUS, '3800', T.CREATE_DATE, NULL)) AS "3800",
MAX(DECODE(T.STATUS, '4000', T.CREATE_DATE, NULL)) AS "4000",
MAX(DECODE(T.STATUS, 'S2', T.CREATE_DATE, NULL)) AS "S2",
MAX(DECODE(T.STATUS, 'S3', T.CREATE_DATE, NULL)) AS "S3",
MAX(DECODE(T.STATUS, 'V2', T.CREATE_DATE, NULL)) AS "V2",
MAX(DECODE(T.STATUS, 'V4', T.CREATE_DATE, NULL)) AS "V4",
MAX(DECODE(T.STATUS, 'S5', T.CREATE_DATE, NULL)) AS "S5",
MAX(DECODE(T.STATUS, 'S6', T.CREATE_DATE, NULL)) AS "S6",
MAX(DECODE(T.STATUS, 'C', T.CREATE_DATE, NULL)) AS "Cancelled",
MAX(DECODE(T.STATUS, 'B', T.CREATE_DATE, NULL)) AS "Billed"
FROM TL_SGM_VEHICLE_ORDER_HISTORY T
WHERE T. VEHICLE_ORDER_ID = 30
GROUP BY T.STATUS, T.VEHICLE_ORDER_ID
ORDER BY T.VEHICLE_ORDER_ID;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货