Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 26150 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
Write query to return all rows sql?
Explain tables in SQL Azure?
What is the Main Difference between ACCESS and SQL SERVER?
How to select true false based on column value in sql server?
What is it’s similarity with sql server?
What is the openxml statement in sql server?
What is implicit mode in sql server?
What is the difference between char, varchar and nvarchar?
what is the difference between openrowset and openquery?
How do I find query history in sql server?
What is default constraint?
What are the difference between primary keys and foreign keys?
Can you tell me about the concept of ER diagrams?
What is checkpoint process in the sql server?
What are the properties of the relational tables?
