TABLE NAME: TESTTABEL table is as follows: Username Usergradeaa 10bb 11AA 20CC 30BB 21AA 12 How to add all users' total scores and return? The final result is UserName Totalgradeaa 42BB 32CC 30
Select Username, SUM (usergrade) from testtabel group by username Order by Username
