write the query for find the top 2 highest salary in sql
server
Answer Posted / santosh kumar
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 ? | 11 Yes | 12 No |
Post New Answer View All Answers
What is use of @@ spid in sql server?
Explain what is sql server english query?
What is the cartesian product of table?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Explain “row_number()” in sql server with an example?
How to deploy the Report?
Detail about the hardware which is supported by SQL server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
When we should use @@error?
Introduction of rollup clause using sum and group by clause?
What is the difference between Clustered and Non-Clustered Index?
What is etl - extraction, transformation, and loading?
What is nolock hint in sql server 2008
Can sql servers linked to other servers like oracle?
What are commit and rollback in sql?