Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25626 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 to write character string constants or literals in ms sql server?
What is a join in sql? What are the types of joins?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Explain what is sql server english query?
What is the difference between deallocate cursor and close cursor?
What is the report builder?
Tell me what are the advantages of using stored procedures?
Why do we use non clustered index?
What is @@rowcount in sql?
Does an index slow down updates on indexed columns?
Explain “not null constraint” in sql server?
How many types of schemas are there?
What is server-level principal?
How to find the version of sql server? : sql server database administration
How do I find the sql server version?
