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)
Data Visualisation Aurora
Hadoop and Big Data
Agile and SAFE
New York, NY 10012, US
© Copyright 2018-2020 www.madanswer.com. All rights reserved. Developed by Madanswer.