Need Help on Oracle query

Hi All,

I was trying to build a query to retrieve the cumulative data for the day and month at the same time.

I am able to get the data for today but i m not able to get the cumulative data for the month in the same query.

Its basically i need both the data in the same query.

Thanks
Rr_channs:)

Check ROLLUP function, it may be what you need.