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

select distinct top 2 salary from EMP order by salary desc

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

User wants only to display only pdf as export option in report manager. How to achieve this?

253


Equi join and non equi join is possible with sql server?

974


What are parameterized reports? What are cascading parameters in ssrs reports?

156


How many levels of sp nesting are possible?

977


Distinguish between commit and rollback?

914


What is ddl command?

944


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1075


Explain what is the use of custom fields in report?

884


How to connect sql server management studio express to sql server 2005 express?

989


What do you think of this implementation? Can this be implemented better?

898


Explain how you can deploy an SSRS report?

141


How will you optimize a stored procedure optimization?

985


How to disable a login name in ms sql server?

1087


What are types of storage modes? : sql server analysis services, ssas

1001


Difference between drill down and drill through report.

914