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

What is mysql community server?

972

What is mysql data directory?

1051

How can we run batch mode in mysql?

1125

What happens if null values are involved in expressions?

1084

What is the usage of regular expressions in mysql?

942

What is save point in mysql?

1001

Is mysql a programming language?

949

What is a csv table?

1046

what is the default port for mysql server? : Mysql dba

1099

What is mysqli_result?

983

What are Heap tables?

1636

What is auto increment in mysql?

1012

What are programming functions?

998

How to calculate the difference between two time values?

1060

What is a result set object?

1010