Question

Suppose a Student table has two columns, Name and Marks. How to get name and marks of top three students

Answer 1

SQL statement

Explanation:

SQL statement to get name and marks of top three students:

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

To retrieve data from table:

Select * from table_name;

Structured Query Language is one of the database languages that helps in creating, maintaining and retrieval of the data from relational database such as PostGre, MySQL, Oracle, SQL Server, etc.