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

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

Related questions

+1 vote
asked Jun 13, 2020 in HBase by Robindeniel
+2 votes
asked Jun 17, 2019 in Agile by tempuser123
0 votes
asked Jun 6, 2019 in Data Handling using R by tempuser
+2 votes
asked Jan 14, 2022 in Sql by GeorgeBell