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

write the query for find the top 2 highest salary in sql
server

Answer Posted / santhosh kumar

select Distinct Top 2 Salary from EMP order by Salary desc

Is This Answer Correct ?    7 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can change a cross join into an inner join?

913


How to provide default values to function parameters?

1054


What happens if ntwdblib.dll is missing on your machine?

1102


How do I debug a stored procedure in sql server?

1030


How would we use distinct statement? What is its use?

1024


Write SQL queries on Self Join and Inner Join.

1072


What is the sql profiler?

901


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

897


How to execute a sql statement using mssql_query()?

978


What purpose does the model database server?

1055


How to use transact-sql statements to access the database engine?

999


How to invoke a trigger on demand?

1029


How to set database to be single_user in ms sql server?

970


What is the purpose of object explorer and its features? : sql server management studio

1124


What is the process of indexing?

945