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 nth highest salary

Answer Posted / dilip

SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf and 3nf?

893


What is the fillfactor concept in indexes?

990


According to you what goes into making the best database administrator? : sql server database administration

981


What do we need queues in sql service broker?

1073


Explain system functions or built-in functions? What are different types of system functions?

985


What are the rendering extensions of ssrs?

157


Define right outer join?

984


What is the difference between char, varchar and nvarchar?

1027


How to populate a table in sql server?

966


Where the sql logs gets stored?

992


What is the ‘fillfactor’?

973


How can you append an identity column to a temporary table?

957


What is the purpose of forms?

961


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1034


Explain linked server in sql?

1229