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
Why is mysql popular?
Give string types available for column?
What is slow query log in mysql?
What is mysql procedure?
How to rename an existing column in a table?
What is the maximum number of records in mysql table?
Explain csv tables.
State the differences between mongodb and mysql.
What is dump in mysql?
What is full text indexing in mysql?
How do you flush privileges?
How do I restore a mysql database dump file in linux?
How many groups of data types?
How many columns can you create for an index?
What is prepare statement in mysql?