Use Aggregate function without group By clause...

If you want to use Aggregate function in sql queries your query looks like this

Select StudentID, SUM(Mark) as Total  from student Group By StudentID,Mark

but you can write your query like...

Select StudentID, SUM(Mark) Over()  from student