write query for fourth maximum salary from employee table
Answer Posted / prabhjeet singh sethi
select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know nested transaction?
What is explicit mode in sql server?
Scalability, Availability, Integration with internet, etc.)?
what method you can use to reduce the overhead of Reporting Services data sources?
Which Model uses the SET concept
What is CTE in SQL
Can you explain about buffer cash and log cache in sql server?
How to loop through returning rows?
What are the components of sql server service broker?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is raid, and how it can influence database performance?
Do you know what is lock escalation?
What is resource governor in sql server?
What is the difference between char, varchar and nvarchar?
What is user-defined multi-statement table-valued function?