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

What is the maximum number of records in mysql table?

533


What is mysql_query?

532


Does mysql use t sql?

646


How large can a mysql database become?

578


How to do login in mysql with unix shell.

621






Is mysql same as sql?

556


Which mysql function is used to concatenate string?

891


How do I view mysql logs?

574


What are the functions of mysql?

547


Is mysql good for big data?

574


what is constraints? Also explain the different types of constraints?

611


What are the difference between now and current_date in mysql?

781


Why mysql is used with php?

571


Why do we use views instead of tables?

567


How do I copy a table in mysql workbench?

532