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)

Related questions

+1 vote
asked Jun 13, 2020 in HBase by Robindeniel
0 votes
asked Feb 2, 2021 in Sql by SakshiSharma
...