Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25685 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / suri
select max(m.total_amt),e.emp_name, d.dept_name from
hr_employee_salary_mst m,
hr_employee_mst e, hr_dept_table d
where d.dept_id=e.dept_id
and m.employee_id=e.emp_id
group by d.dept_name,e.emp_name,d.dept_name
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
How can I change procedure name in sql server?
What is sub-query in sql server? Explain its properties.
What is report subscription?
What is the sql case statement used for?
What are the different subsets of sql?
What is the fillfactor concept in indexes?
What is the difference between implicit and explicit transaction?
What is the difference between cartesian product and cross join?
What is difference between temp table and cte?
Tell me the difference between clustered and non-clustered index?
What are constraints in microsoft sql server?
What stored by the msdb?
How to list all schemas in a database?
What is the difference between web edition and business edition?
What are the advantages of user defined function?
