How to find out the second largest element from mysql table
- 15 Answers
- 24866 Views
- I also Faced
- E-Mail Answers
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 string data types?
Which statement is used to delete a table in MySQL.
How we get sum of column.
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What can I do with mysql?
What are the differences between mysql vs sql server?
What is the difference between the primary and unique key in mysql?
Is mysql deprecated?
What is the maximum number of columns per table?
Write a query to create a database and a table?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What is mysql in linux?
Why do we need mysql?
How you will Show unique records.
Are stored procedures precompiled?
