query for maximum marks

[Samanthi perera]

this is my question

Given a Table named “Students” which contains studentid, subjectid and marks. Where there are 10 subjects and 50 students. Write a Query to find out the Maximum marks obtained in each subject

[Jan Cumps]

Hi. Hope this is not your homework.


In your sql statement,
use the "max()" aggregation function to find the maximum marks,

and
to make the max() function aggregate on subject level,
group by subjectid by adding a "group by" clause.