Question

suppose a student column has two columns name and marks. how to get name and marks of top three students

Answer 1

When a student column has two columns name and marks then it happens when let’s assume 100 when three students have the highest marks and four other students have marks 60, 70, 80 and 90 respectively.\

Select * from `student` where subject='science' order will return you three rows with GROUP BY clause. It will return three rows of the students and top three distinct marks.