Find top Nth employee from each department in terms of
salary?
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 partition function in sql server?
What is xml datatype?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are the joins in sql server? : sql server database administration
Can a rule be bound to any column of any data type?
How to delete existing triggers using "drop trigger"?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How will you monitor replication latency in transactional replication? : sql server replication
What is a heap?
What is the temp table?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are triggers in ms sql server?
Tell me what are the advantages of using stored procedures?
Why use “in” clause in sql server?