Question

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

Answer 1

SELECT statement is used to get name and marks of top three students.

Explanation:

SQL query is

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

SQL (Structured Query Language)

It is utilized to perform activities on the records put away in the database, for example, refreshing records, erasing records, making and altering tables, sees, and so forth.  

Functions of SQL (Structured Query Language)

To make new databases, tables and perspectives.

To embed records in a database.

To alter records in a database.  

To erase records from a database.  

To recover information from a database.