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 / suhail qaiser

Answer Posted / suhail qaiser

or if u want 2nd highest then write this query

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

Is This Answer Correct ?    29 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is explicit cursors?

1123

What is an execution plan? How would you view the execution plan?

1127

What are different backups available in sql server?

1153

How can you list all the columns in a database?

970

Explain transaction server auto commit?

1088

what are different types of backups available in sql server? : Sql server database administration

983

What is a full text index?

964

Where are SQL server users names and passwords are stored in sql server?

1325

What is the purpose of data source?

1088

What is the difference between grant and with grant while giving permissions to the user?

1024

How to verify a user name with sqlcmd tool?

1118

What happens if date-only values are provided as date and time literals?

1074

What is the downside of using udf?

1160

What are the advantages of the mirroring?

1147

Explain transaction server distributed transaction?

1036