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

select max(sal) from emp
where sal !=(select max(sal) from emp);

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is de-normalization and what are some of the examples of it?

972


What is #table in sql server?

1038


What is difference between global temporary tables and local temporary tables?

1229


How to loop through result set objects using mssql_fetch_array()?

1071


Explain how would you store your query in an SSRS report or a Database server?

128


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2208


How to find the list of fixed hard drive and free space on server?

1190


What are the rendering extensions of ssrs?

157


Explain what are the restrictions while creating batches in sql server?

1064


What is it unwise to create wide clustered index keys?

1007


How to create user messages with print statements in ms sql server?

983


How to create hyperlink from returned sql query ?

1121


What is an identity?

1008


Explain user defined functions?

985


Difference between Inner vs outer joins?

944