How to find out the second largest element from mysql table
Answer Posted / deo ram yadav
select BranchName
from Account
order by Balance desc limit 1, 1;
Note: ,BranchName' is attribute and 'Account' is table. 1,1 means leave one row and then take another one row.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create a new table in mysql?
How to dump a table from a database.
What is the difference between myisam dynamic and myisam static in mysql?
What are the different mysql database engines?
Is null in mysql?
How do I create a schema in mysql?
How many threads can mysql handle?
How do I declare a variable in mysql?
Why we use mysql workbench?
What is mysql good for?
What are the differences between char and varchar?
How to increment dates by 1 in mysql?
What is the maximum connection pool size?
How to calculate the difference between two dates?
What does blob mean in mysql?