Query To Find Second Highest Marks Of A Student?

1.	Query To Find Second Highest Marks Of A Student?
Answer» Based On the Below STUDENT table We are Written All the Queries. SELECT MARKS FROM Student ORDER by marks DESC limit 1, 1; Based On the Below Student table We are Written All the Queries. SELECT marks FROM Student ORDER by marks DESC limit 1, 1;

Answer»

Based On the Below STUDENT table We are Written All the Queries.

SELECT MARKS FROM Student ORDER by marks DESC limit 1, 1;

Based On the Below Student table We are Written All the Queries.

SELECT marks FROM Student ORDER by marks DESC limit 1, 1;

Discussion