Ask a Question

Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.

0 votes
in Sql by

Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.

1 Answer

0 votes
by

SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)

Powered by Madanswer
...