title: How to find max value and its associated field values in SQL?
body: <p>Say I have a list of student names and their marks. I want to find out the highest mark and the student, how can I write one select statement to do that?</p>