How to get Row Value & Sum/ Aggregate in Same row? (SQL Server)
Yes, there is a way. It's called "window aggregate functions":

select
    A.name, A.score, 
    sum(A.score) over () as total
from myTable A ;


The OVER () means that the aggregate (sum in this case) is over the whole result set. If you wanted the total over say different names (assuming you had rows with same name, you could use OVER (PARTITION BY name).