Jul 10 in Sql

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

1 Answer

Jul 10

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

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Jun 17, 2019 in Agile
May 13 in Oracle
Dec 31, 2019 in Data Science