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 create command?
How to check if stored procedure is running in sql server?
Difference between aggregate functions of sql?
Is it possible to have clustered index on separate drive from original table location?
What is table level trigger?
How does a profiler work?
Which command is used for user defined error messages?
1 01 101 01010
Do you know what are pages and extents? : SQL Server Architecture
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How to find index size for each index on table?
What are database states in ms sql server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is the difference between for auto and for nested?