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
how to overcome kernel isssues
What is difference between unique and primary key?
What is openxml in sql server?
what kind of lan types do you know? : Sql server database administration
Why we use trigger in sql server with example?
What are drillthrough reports?
How efficient you are in oracle and SQL server?
When does a workload on SQL Azure get throttled?
What are different replication agents and what's their purpose? : sql server replication
Is it safe to delete log files?
What is mean by candidate key?
Can sql server 2016 run on windows 7?
Define Wed Edition in SQL Azure?
What is indexing and its types?
What does man by sql wildcard characters in sql server?