My Table Data as follows:
Invoice_id ;Invoice_Number ;Service_Head; Amount
1; 1 AF 1200
2; 1 Excise_Duty 10000
3 1 Deumorages 1500
4 2 AF 1500
5 2 Excise_Duty 12000
6 2 Deumorages 2000
I want SQL query to get following Result Set:
Invoice_Number ;AF; Excise_Duty; Deumorages ; Total
1 1200; 10000 1500 12701
2 1500; 12000 2000 15502
please suggest me...
Thanks
Sekhar C