Viewing 2 posts - 1 through 2 (of 2 total)
the below query is another way which gives the desired output but this is also a workaround.
select top 1 s.studentid, s.name, sum(marks)
from tbl_marks m inner join tbl_student s
on m.studentid=s.studentid
group by...
January 18, 2013 at 12:27 am
#1578571
the below query works and i get the desired o/p but i dont think it is an efficient way.
select s.StudentID, s.name, sum(marks)
group...
January 18, 2013 at 12:20 am
#1578568