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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / arun kumar k s

Answer Posted / arun kumar k s

select Distinct Top 2 Salary from EMP order by Salary desc

Is This Answer Correct ?    111 Yes 59 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

optimization techinques

2681

How will you find out if there are expensive SQL statements running or not?

1017

Who developed sql server?

941

What are the different index configurations a table can have?

967

What is postgresql server?

1010

What is the difference between commit and rollback?

948

What is a deadlock and what is a live lock?

1003

Where are sql server user names and passwords stored in sql server?

1098

How many tables can be joined in SQL Server?

1069

How to get a list all databases on the sql server?

1108

How to find related tables in sql server?

952

What are different types of join?

1320

What happens if an integer is too big for int date type?

980

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1009

Which tcp/ip port does sql server run on? How can it be changed?

1045