write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 66049 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
Explain go command in sql server?
What is microsoft sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How do use Having,Group by,Group function in SQL?
What is your recommendation for a query running very slow? : sql server database administration
How do you drop an index?
How to write a query with a right outer join in ms sql server?
Do you know what are pages and extents? : SQL Server Architecture
What is the significance of master, tempdb and model databases?
What number aggregate functions are accessible there in sql?
How to rename an existing column with sql server management studio?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What do you mean by an execution plan? Why is it used?
Where are SQL server users names and passwords are stored in sql server?
If no size is defined while creating the database, what size will the database have?
