Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Is mysql case-sensitive?

877


What is meant by sharding?

913


What storage engines are used in MySQL?

1039


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1006


What is indexing in mysql?

941


What is mysql command line?

1029


Can I install mysql on mac?

965


How do I install mysql workbench?

887


What is the difference between mysql and oracle?

955


What are procedures in mysql?

930


What are the advantages of a procedure?

907


What is the difference between a heap table and temporary table?

929


Explain the storage engines in mysql?

986


What are date and time intervals?

971


What is the role of a limit in a mysql query?

993