Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25110 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
Find columns used in stored procedure?
What are the different types of sql server replication? : sql server replication
How to drop an existing table with "drop table" statements in ms sql server?
Does group by or order by come first?
Explain something about security and SQL Azure?
Explain different types of index?
Can you explain the disadvantages/limitation of the cursor?
What do you understand by intent locks?
What is the difference RDBMS and Graph Database?
What is the difference between functions and scalar functions?
Difference between DELETE and TRUNCATE?
What are various limitations of the views?
What is indexing a document?
What is the simplest way to create a new database in ms sql server?
What is difference between standardization and normalization?
