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 the use of mysql workbench?

1017

What is prepare statement in mysql?

989

What is clob datatype?

885

What is a longblob?

948

What is difference between oracle and mysql?

924

What is mysql_connect?

952

How do I delete a mysql user?

847

How do I run mysql?

1010

What is the difference between BLOB AND TEXT?

1150

What is “i_am_a_dump” flag in mysql?

1069

Is mongodb faster than mysql?

953

Can you tell the difference between $message and $$message?

971

What is data type for image in mysql?

870

Create table employee (eno int(2),ename varchar(10)) ?

1008

What is blob datatype in mysql?

936