Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out the second largest element from mysql table
- 15 Answers
- 28964 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 is a table schema?
What is mysql_pconnect?
What are the advantages and disadvantages of using mysql?
Can you tell how to find the number of rows in a resultset using php?
What is 'mysqld'?
What is the phantom problem?
What is a heap table?
What language does mysql use?
How can we get the number of rows affected by query?
What is InnoDB?
What is the maximum connection pool size?
What are the disadvantages of mysql?
What is a select query?
What are stored procedures and functions?
How do I select a table in mysql?
