John

John

  • 1.3k
  • 928
  • 109.6k

Sum of each user data in SQL SERVER

Sep 27 2017 6:27 AM
 Name    Price Discount
 A 10    2
 A 20 5
 A 55 3         
 Total    85 11
 B 5 6
 B 15 9
 B 10 2
 Total 30 17
 
 
 
The above table has separate total for each user. How to calculate it in sql server and return and different dataset or a combine dataset 

Answers (7)