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

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

Is This Answer Correct ?    65 Yes 88 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the difference between union and union all in sql server?

1043


What is sql or structured query language?

1201


What is set nocount on?

995


What is clustered index

1061


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1026


What are distributed partitioned views?

1137


Which sql server table is used to hold the stored procedure scripts?

1111


What command is used to create a database in the sql server and how?

1243


Write an SQL query to obtain the 2nd highest salary.

1126


Does partitioning improve performance sql server?

1032


What are Spatial data types in SQL Server 2008

1073


How to execute stored procedure and set temp table in sql server?

1101


Define Unique Key?

1069


What are the advantages of using third-party tools?

1038


Can binary strings be used in arithmetical operations?

986