Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 22652 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
What is the difference between update lock and exclusive lock?
Explain transaction server implicit?
Can you explain powershell included in sql server 2008?
What are types of subqueries?
Explain the use of containers in ssis and also their types?
Can you tell me about the concept of ER diagrams?
What is the difference between stored procedure and user defined functions?
What is the optimization being performed in oracle and SQL Server?
What is dml command?
What is the use of @@spid?
What is mapping schema?
What are the system database in sql server 2005?
How do I debug a stored procedure in sql server?
Define inner join? Explain with an example?
What is federation member?
