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

Is pl sql and postgresql same?

1185


how to convert character strings to dates? : Sql dba

1103


Does sql profiler affect performance?

1048


What is delete command in sql?

1176


What are database links used for?

1099


How to Declare Fixed Length String Value In PL SQL

1209


what are set operators in sql? : Sql dba

1110


What is the use of sqldataadapter?

1028


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1111


What are the benefits of pl sql?

1186


What are sql triggers used for?

1036


What is sql key?

1047


What is difference between nchar and nvarchar?

1104


what is the difference between delete and truncate statement in sql? : Sql dba

1351


how would you get the current date in mysql? : Sql dba

1020