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 statement is used to delete a table in MySQL.
Is sqlite faster than mysql?
Do I need to pay for mysql?
Can we write pl sql mysql?
Can you tell the difference between $message and $$message?
What is general log in mysql?
What is flush privileges in mysql?
How do you insert a table?
What are the differences between char and varchar data types?
What is mysqli_select_db?
Write a query to fetch common records between two tables using mysql?
What is the full meaning of mysql?
How to get data from mysql in php?
What is the size of mysql database?
How do I setup a mysql database?