Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24516 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
Explain the properties of a relational table?
What is tempdb in sql server?
Explain candidate key, alternate key, and composite key?
How would you add a section to a table?
How to encrypt Strored Procedure in SQL SERVER?
What is policy management?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Why use “in” clause in sql server?
What are cursors stored procedures and triggers?
Define inner join in sql server joins?
How to delete a database in ms sql server?
How to list all login names on the ms sql server?
Explain relational data?
What is encryption key?
Can an entity have two primary keys?
