Selecting each max value from different data in a column

Question

Ok i will tell the analogy, i have a student table. The column of the table is ID, name, Major, Score. I want to find each max value of student from different Major. That's my question

Answer 1

This could help you.
https://www.sololearn.com/learn/SQL/1862/?ref=app
https://www.sololearn.com/learn/SQL/1854/?ref=app

Answer 2

Use GROUP BY and MAX.