Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 11928 Views
- I also Faced
- E-Mail Answers
Answer Posted / v rajkumar
select salary from Emp a where 4 = (select count(distinct
(salary)) from Emp b where b.salary>= a.salary)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between implicit and explicit transaction?
Which autogrowth database setting is good?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is precedence constraint?
When we should use and scope of @@identity?
What is the sql case statement used for? Explain with an example?
What is the difference between set and select?
What are the extra roles available in msdb? : sql server security
How does stuff differ from the replace function?
Ways to improve the performance of a SQL Azure Database?
Which is better statement or preparedstatement?
What is update locks?
What is conditional split?
How to truncate the log in sql server 2012? : sql server database administration
What is the difference between varchar and nvarchar datatypes?
