Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25629 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
Explain various data region available in ssrs with their use?
What are the different kinds of ssrs reports?
How to find related tables in sql server?
What is molap and its advantage? : sql server analysis services, ssas
Define magic tables in sql server?
Tell me when is the update_statistics command used?
what is the difference between count(*) and count(1) ?
What are the dmvs? : sql server database administration
What is normalization process?
Explain about temporary stored procedure?
How can you hide the sql server instances?
What do you know about normalization and de- normalization?
What are the restrictions applicable while creating views? : SQL Server Architecture
Tell me what is the significance of null value and why should we avoid permitting null values?
How to check table values in sql server?
