This query will fetch you the number of Purchase Orders created in month. The input parameter passed is from date and to date. This will group the number of PO created into months and provide you with the data as expected.
SQL Query:
SELECT
TO_CHAR(creation_date,’MON-YY’) month,
COUNT(*) “Number of POs created”
FROM
po_headers_all
WHERE
creation_date BETWEEN TO_DATE(:from_date_ddmonyy,’DD-MON-YY’)
AND TO_DATE(:to_date_ddmonyy,’DD-MON-YY’) + 1 – 1 / ( 24 * 3600 )
GROUP BY
trunc(creation_date,’MM’),
TO_CHAR(creation_date,’MON-YY’)
ORDER BY
trunc(creation_date,’MM’);
Recent Posts