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
Is mysql case-sensitive?
What is meant by sharding?
What storage engines are used in MySQL?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What is indexing in mysql?
What is mysql command line?
Can I install mysql on mac?
How do I install mysql workbench?
What is the difference between mysql and oracle?
What are procedures in mysql?
What are the advantages of a procedure?
What is the difference between a heap table and temporary table?
Explain the storage engines in mysql?
What are date and time intervals?
What is the role of a limit in a mysql query?