A ."CreateDate" BETWEEN TO_DATE (#{startDate}, 'yyyy-mm-dd ')
AND TO_DATE (#{endDate}, 'yyyy-mm-dd')
1. 日期区间写法
SELECT COL01, DOU01, DOU02
FROM (SELECT B.MC AS COL01,
SUM(A.involvedMoney) AS DOU02,
COUNT(*) AS DOU01
FROM CKB_MESSAGE A
INNER JOIN MT_RULE B ON (A.TriggerType = TO_CHAR(B. ID))
INNER JOIN CK01_YHRY Y ON (A.PersonID = Y.GH)
WHERE TO_CHAR(A.CreateDate) >= '2017-04-01 00:00:00'
AND TO_CHAR(A.CreateDate) < '2017-09-14 23:59:59'
GROUP BY B.MC
ORDER BY COUNT(*) DESC) T
WHERE ROWNUM < 10