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
- 10490 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 the difference between UNION and UNIONALL?
What are magic tables in sql server?
can SSRS reports Cache results?
What is self contained sub query?
What are the different type of replication in sql server?
What is truncate table?
What is a trigger and its types?
Explain what is sql server english query?
What is the use of commit?
What is acid properties?
How to create a scrollable cursor with the scroll option?
How to compare the top two records using sql?
What is the purpose of linked server configuration in sql server?
What is the difference between a primary key and a unique key? Are they the same?
Explain foreign key in sql server?
