ORACLE的SQL高手帮我看下错误，谢谢了

显示全部楼层 · 2009-4-29 16:25:21

SELECT SUM(A.JILU),
CASE A.XF_CREATEDATE WHEN TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')>'20050101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20060101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20070101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20080101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20090101' THEN '2009'
ELSE A.XF_CREATEDATE
END 'SEASON'
FROM
(SELECT COUNT(*) JILU,XF_CREATEDATE FROM XF_PROMPOOLH
GROUP BY XF_CREATEDATE
ORDER BY XF_CREATEDATE) A
GROUP BY SEASON
刚才改了一下，还是不对
SELECT SUM(A.JILU),
CASE WHEN TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')>'20050101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20060101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20070101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20080101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20090101' THEN '2009'
ELSE A.XF_CREATEDATE
END AS 'YEAR'
FROM
(SELECT COUNT(*) JILU,XF_CREATEDATE FROM XF_PROMPOOLH
GROUP BY XF_CREATEDATE
) A
GROUP BY YEAR

千问 · 2009-4-29 16:25:21

首先case处用法不对该 CASE WHEN TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')>'20050101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')'20050101' AND TO_CHAR(A.XF_CREATEDATE,'YYYYMMDD')<'20051231' THEN '2005' WHEN TO_CHAR(A.XF_CREATEDATE,'YYYY...