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
State the differences between mongodb and mysql.
What is row locking in mysql?
What is the latest mysql?
What is database migration in mysql?
What are the applications required to support mysql?
What are the different data types in mysql?
How we can get the current date in mysql?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Will mysql remain free?
How does mysql encrypt passwords?
What is insert query in mysql?
What is blob in mysql?
Can you tell a way to know the number of days between the two given dates in php?
using primary can we relate two table, with out foreign key?
How can you retrieve a particular number of records from a table?