Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 26171 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / pradeep nambiar
select distinct(a.salary) from employee a where &n=(select
count(distinct(b.salary)) from employee b where
a.salary=b.salary)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How we can refresh the view?
What is user-defined function?
Explain different types of self contained sub query?
What is subquery explain with example?
How to set the current database in ms sql server?
What is difference between rollback immediate and with no_wait during alter database?
What is the benefit of normalization?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Define constraints and give an example of their use?
What is function of CUBE ?
How to choose all records from the table?
What is difference between table aliases and column aliases? Do they affect performance?
Differentiate between mongodb vs. Sql server?
When would you use the stored procedures or functions?
what is database replicaion? : Sql server database administration
