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 check the 3rd max salary from an employee table?

Answer Posted / akilis.org@hotmail.com

Let us Assume
Table Name=salary
Column Name=maxsal

select * from salary order by maxsal desc limit 2,1;

Enjoy the simple code :)

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is procedure explain with example?

896


How to run pl sql program in mysql?

942


how to see the create table statement of an existing table? : Sql dba

947


How many types of privileges are available in sql?

1286


Why is a trigger used?

890


What are schema-level triggers?

1047


How many times can we commit in a loop?

959


How do I use google cloud in sql?

1034


What is the basic form of sql query?

881


How do I make sql search faster?

937


What is mutating trigger?

971


Can we call stored procedure in function?

905


how to check server status with 'mysqladmin'? : Sql dba

1018


What is foreign key in sql with example?

892


Why is sql important?

1027