write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 69281 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
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
How to defragment indexes with alter index ... Reorganize?
What is xdr?
What is enhanced database mirroring in sql server 2008?
How to sort the query output with order by clauses in ms sql server?
Explain syntax for disabling triggers?
Does a server store data?
List the data types available in mssql?
Explain Geometry datatype in sql server 2008 with example
difference between Clustered index and non clustered index ?
How to change the password of a login name in ms sql server?
What is an expensive query?
How to encrypt data between dialogs?
How to rebuild master databse?
How to delete an existing row with delete statements in ms sql server?
What type of locking occurs during the snapshot generation? : sql server replication
