How to find out the second largest element from mysql table

Answer Posted / lekhraj deshmukh

select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;

Is This Answer Correct ?    21 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which statement is used to delete a table in MySQL.

702


Is sqlite faster than mysql?

717


Do I need to pay for mysql?

697


Can we write pl sql mysql?

737


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

768


What is general log in mysql?

708


What is flush privileges in mysql?

778


How do you insert a table?

701


What are the differences between char and varchar data types?

759


What is mysqli_select_db?

755


Write a query to fetch common records between two tables using mysql?

814


What is the full meaning of mysql?

741


How to get data from mysql in php?

684


What is the size of mysql database?

717


How do I setup a mysql database?

729