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 root?

896

Define REGEXP?

1048

Explain % and _ inside like statement?

959

What is the latest mysql?

896

Which statement is used to delete a table in MySQL.

862

change column name and make a unique column so we get no dupes.

923

What is the usage of regular expressions in mysql?

861

What is the difference between char and varchar in mysql?

1017

How to convert character strings to dates?

1039

How can you calculate the sum of any column of a table?

993

How to delete a table.

874

What is session variable in mysql?

916

what is a cursor? : Mysql dba

946

How to Change a users password from unix shell.

1036

What are the 5 r's of managing behaviors?

1035