chkri.panati (6/21/2013)
SELECT StudentName,Class,MAX(Marks) AS MAX_Marks FROM Student123GROUP BY StudentName,Class
ORDER BY Class
I'm pretty sure that's not going to work with the original data and table structure given in the original post.
--Jeff Moden
Change is inevitable... Change for the better is not.