SELECT a.x xs , nvl (b.y, 0) yFROM (SELECT to_char (to_date (?, 'yyyy-MM-dd') + (LEVEL - 1), 'yyyy-MM-dd') x FROM dual CONNECT BY TRUNC (to_date (?, 'yyyy-MM-dd') + LEVEL - 1) = ? AND to_char (h.createdate, 'yyyy...
显示全部SELECT a.x xs
, nvl (b.y, 0) y
FROM (SELECT to_char (to_date (?, 'yyyy-MM-dd') + (LEVEL - 1), 'yyyy-MM-dd') x
FROM dual CONNECT BY TRUNC (to_date (?, 'yyyy-MM-dd') + LEVEL - 1) <= TRUNC (to_date (?, 'yyyy-MM-dd'))) a
, (SELECT t.x
, count (1) y
FROM (SELECT to_char (a.x, 'yyyy-MM-dd') x
FROM (SELECT h.createdate x
FROM wfl_taskinfo_his h
WHERE h.tradeno IN ('000040', '000080') AND to_char (h.createdate, 'yyyy-MM-dd') >= ? AND to_char (h.createdate, 'yyyy-MM-dd') <= ?) a) t
GROUP BY t.x) b
WHERE b.x ( +) = a.x
ORDER BY a.x asc;
这个是Oracle下的sql可以执行,但是我现在要转换成DB2下可执行的SQL,上面的伪劣level和connect by怎么转换啊?,还有一些函数DB2也不支持,求指教!!!
收起