Query to get number of PO created

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’);