write the query for find the top 2 highest salary in sql
server
Answer Posted / ram murthy
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is the cartesian product of table?
What is the difference between lock, block and deadlock? : sql server database administration
What is the datatype of rowid?
What are rest-style architecture's?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is spatial nonclustered index
Will the writetext statement activate a trigger?
What is difference between rownum and row_number?
What are the different types of upgrades that can be performed in sql server?
how to do partition in sqlserver
when would you go for denormalization? : Sql server database administration
What are the types of resultset?
Explain unique key in sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is the difference between executequery () and executeupdate ()?