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 / venuprasadh

SELECT MIN(SALARY) AS Salary FROM user WHERE SALARY IN
(SELECT DISTINCT TOP 3 SALARY FROM user ORDER BY SALARY DESC);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter binary string literals in ms sql server?

1164


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

909


How can I add Reporting Services reports to my application?

129


What is the beast way to write CTE in SQL Server ?

1046


Why I am getting this error when dropping a database in ms sql server?

1073


What are the default system databases in sql server 2000?

1031


Which joins are sql server default?

1013


What is candidate key with example?

976


Does hive support indexing?

962


How can we remove orphan records from a table?

986


Explain isolation levels that sql server supports?

1040


List out what other servers you can use with ssrs?

139


How do I start sql server 2016?

910


what is the difference between a primary key and a unique key? : Sql server database administration

1003


What is partitioned view?

900