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

Why is mysql popular?

676


Give string types available for column?

764


What is slow query log in mysql?

770


What is mysql procedure?

725


How to rename an existing column in a table?

759


What is the maximum number of records in mysql table?

672


Explain csv tables.

734


State the differences between mongodb and mysql.

810


What is dump in mysql?

662


What is full text indexing in mysql?

723


How do you flush privileges?

728


How do I restore a mysql database dump file in linux?

714


How many groups of data types?

732


How many columns can you create for an index?

694


What is prepare statement in mysql?

750