In this query, I will show you how to fetch the highest value in a Group or Category. We will be creating a sample table called Student - StudentId, SubjectId and Marks. We have to find out that in each Subject(group), which Student scored the highest marks.
Query to fetch Student with highest marks in each Subject
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|