A school has classes. Each class has students. Each student may take up one or several courses.
One only table with thousands of rows contains the following columns (and some others):
- Student´s class
- Student id-number
- Student's course
- Student's grade (in the course)
- Some other rows. This table has about 25 rows
I need an only SELECT that brings ALL ROWS for each student's highest grade (grades are numbers, not letters).
In the example bellow, I have listed a fragment of the table and I have emphasized with bold and italic characters the rows that are supposed to be selected:
- Class-A 100001 Math&n
View Complete Post