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

Explain the different types of mysql joins.

911

How to use in conditions?

1002

What is mysqlcommand?

991

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

967

How to dump a table to a file with 'mysqldump'?

1020

What is a definer?

867

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1448

How do I truncate all tables in mysql?

976

What happens if null values are involved in expressions?

1028

How do I automate a backup in mysql?

984

How can you add and remove any column of a table?

936

Can a table have multiple primary keys?

894

Is mysqli deprecated?

956

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

930

write a query to mysql in safe mode and to change the root password

954