Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13625 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
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the different subsets of sql?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain system functions or built-in functions? What are different types of system functions?
Does view occupy space?
How do I create a trace in sql server?
What is self contained sub query?
Can we shrink data file in sql server?
Can sql servers link to other servers like oracle?
What kind of problems occurs if we do not implement proper locking strategy?
What are the kinds of subquery?
Disadvantages of the indexes?
What is a scheduled job or what is a scheduled task?
What are the source of constraints?
How to connect php with different port numbers?
