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
- 10476 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sumesh.s.g
--Sumesh.S.G--
SELECT TOP 1 salary
FROM (select top 3 Salary
from dbo.TBL_Employee
order by Salary desc) as TemTable order by Salary asc
--Happy coding--
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different types of backups avaialabe in sql server 2005?
What is the difference between sdf and mdf?
How do you set a trace flag in sql server?
What is a view in sql?
What does it mean to manipulate data?
What is change data capture (cdc) in sql server 2008?
How to skip remaining statements in a loop block using continue statements?
Explain how you can deploy an SSRS report?
What is a trigger and its types?
What do you mean by a Composite primary key?
Explain tablesample?
How do I get to sql server configuration manager?
Tell me what is normalization? Explain different forms of normalization?
Is sql server a database?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
