Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12621 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
What is wide table?
Can you explain what are various ways to enhance the ssrs report?
What is a unique index?
Which data type columns are the best candidates for full-text indexing?
What are the differences between left join and inner join in sql server?
What is Dependency Injection and provide example?
What are the characteristics of modern DBMS?
Explain about remote stored procedure?
Can you edit the .rdl code associated with a linked report?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Why is sql server log file full?
Can we write a distributed query and get some data which is located on other server and oracle database?
How do I uninstall sql server 2014?
Write an SQL query to obtain the 2nd highest salary.
What is 3nf normalization form?
