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

How to handle bulk data?

1318


What are synonyms in sql?

977


what are the differences between binary and varbinary? : Sql dba

1049


How bulk collect improves performance?

1014


What is record variable?

1000


What are expressions?

1021


what is a database? : Sql dba

1183


What is trigger and types?

1030


What is inner join in sql?

1090


How do I view a view in sql?

956


What is a stored procedure in sql with example?

1139


how to include character strings in sql statements? : Sql dba

1081


How do I write a sql query in pgadmin 4?

997


How do you define a foreign key?

1010


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1006