I forgot to post my query
SELECT SUBSTR(TO_CHAR(TRUNC(d.DOWNLOADDATE,'MM')),4,6), COUNT(*) FROM DOWNLOAD d
WHERE d.DOWNLOADDATE BETWEEN TO_DATE('07/01/2005','mm/dd/yyyy') AND TO_DATE(TO_CHAR(SYSDATE,'mm/dd/yyyy'),'mm/dd/yyyy')
GROUP BY TRUNC(d.DOWNLOADDATE,'MM')
ORDER BY TRUNC(d.DOWNLOADDATE,'MM')
this is my query.




Reply With Quote