I am trying to write a query which can provide me Monthly Total depends on the user input date and year to date total also in the same query.
My table has the fields : Application Id, Status, Date.
My query should give an out put
Total Record In Oct-13 = 10
YTD Record Till Oct-13 = 50 (will Add all from Jan-13 -Oct-13)