I want to select all columns and get monthly total in my table.
how am i do this...
plz help me...
Is this you are looking for
Select Project ,Location,Itemtype,Sum(Amount) From mytable Group by Project ,Location,Itemtype,MONTH(Date)