Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.
SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)