select name,marks from Student_Info where marks = (select max(marks) from

How to find out the second largest element from mysql table

Question Posted / prashant chaudhary

Answer Posted / prashant chaudhary

select name,marks from Student_Info where marks = (select
max(marks) from Student_Info where marks <
(select max(marks)from Student_Info ))

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which is faster mongodb or mysql?

843

How to connect html form to mysql database using php?

888

What is definer in mysql trigger?

865

What are the differences between innodb and myisam engines?

923

How do I create a mysql database?

862

Is there a way to see the files which are stored?

922

How to create a new view in mysql?

873

Is mysql same as mariadb?

854

Can varchar be primary key?

879

What is a text delimiter?

873

How do I rename a mysql database?

893

What are slow queries?

849

What are the differences between binary and varbinary?

966

What does mysql flush tables do?

909

Is mysqli secure?

835