I have a different group of company price value in my table in sql server database.Now i have the total price for that group of companies price value.
I want a output for the following format:
Table Details: Group Price
Output : Group Price
A 10 Total 45
B 12 Total 40
C 24 Total 81
How to insert the total row in between the rows of A & B.If is it possible to achieve this output to using procedure. Please any one help to me.