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
Which is faster mongodb or mysql?
How many types of indexes are there in mysql?
What is a select query?
Explain triggers and stored procedures?
What is ndb in mysql?
Explain the different types of mysql joins.
List some comparisons operators used in mysql?
What are the types of queries?
How does mysql store data?
What is the difference between heap table and temporary table?
What is mysql_pconnect?
How can you find out the version of the installed mysql?
Where is mysql password stored?
How can we run batch mode in mysql?
What are mysql queries?