Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25077 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
What is a fill factor?
Explain about service Broker functions?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is page in sql server?
What is left outer join in sql server joins?
Distinguish between nested subquery and correlated subquery?
List all types of constraints in sql server?
What is raid, and how it can influence database performance?
how can u get last observation in an unknown dataset ?
Explain how would you store your query in an SSRS report or a Database server?
How do I create a stored procedure in sql server?
What is default constraint?
How can you check the level of fragmentation on a table?
What is the architecture of ms sql reporting service?
Explain intellisense for query editing
