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

replace the N with wat ever number u want

select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)

Is This Answer Correct ?    26 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between varchar and nvarchar?

987


Explain why variables called the most powerful component of ssis?

1176


What is a domain constraint give an example?

1111


Explain the various types of concurrency problem?

1243


Explain having clause and where clause?

1101


What is temporal table?

938


Explain about Normalization?

1122


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1065


What is always encrypted?

1057


application server is slow what may be the problem

2274


What are policy management terms?

1041


What is the difference between DataRow.Delete() and DataRow.Remove()?

1279


When is update_statistics command used?

1089


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1006


What is difference between equi join and inner join?

1041