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
What are programming functions?
Restore database (or database table) from backup.
How do I download a mysql community server?
Can mysql and mariadb coexist?
How do I view tables in mysql workbench?
What is memory table?
What is the use of pdo?
Why do gaps in sequences occur?
using primary can we relate two table, with out foreign key?
What is the use of mysqli_fetch_array?
What is cursor in mysql?
What are the differences between char and varchar?
Where is mysql data stored?
Explain about reporting services of MYSQL?
How can I create a database in mysql?