select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
- 8 Answers
- 11411 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shekhar
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC) S
ORDER BY salary
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
How to connect ms access to sql servers through odbc?
Is the order of columns in the set clause important in ms sql server?
What is the advantage of sql server?
Explain the difference between control flow and data flow?
How to enter comments in transact-sql statements?
Differentiate between a primary key and a unique key.
Explain the collation?
What happens if time-only values are provided as date and time literals?
Why I am getting this error when renaming a database in ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Does sql server 2000 full-text search support clustering?
Explain transaction server implicit?
Can you use order by when defining a view?
What is named query? : sql server analysis services, ssas
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
