Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24303 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
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
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How do I uninstall sql server 2014?
What is resource governor?
What is Transparent Data Encryption?
Why should one not prefix user stored procedures with ‘sp_’?
How to manipulate data from one table to another table ?
How and why use sql server?
Explain how does the report manager work in ssrs?
How to send a ssrs report from ssis?
What is an execution plan? How would you view the execution plan?
What is self contained multi valued query?
Can another user execute your local temporary stored procedures?
Explain the ways to controlling cursor behavior?
How to delete duplicate records based on single column from a table?
do you know how to configure db2 side of the application? : Sql server database administration
