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...

find the 3rd max salary

Answer Posted / neetu

Select Top 1 Salary from TableName where Salary IN(select
top 3 salary from TableName order by salary Desc) order by Asc

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain important index characteristics?

995


What are different types of data sources?

1024


What is Dependency Injection and provide example?

1126


please differentiate between delete and truncate?

998


How to insert multiple rows with a subquery?

1140


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1043


What is user-defined inline table-valued function?

962


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

989


Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008


What is ssl in sql server?

1083


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

974


Can group functions be used in the order by clause in ms sql server?

1019


What is a DBMS, query, SQL?

1050


Explain difference between cross join and full outer join?

1013


What is meant by indexing?

1024