Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 26174 Views
- RealPage, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / khushboo
select top 1 emp_name,emp_sal from employee order by emp_sal
desc
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / madhu
select top 1 salary,employee from (table name) group by
department
| Is This Answer Correct ? | 10 Yes | 13 No |
Answer / 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 |
Where is my database stored on the hard disk in ms sql server?
Explain user defined functions?
What should be the fill factor for indexes created on tables? : sql server database administration
Describe in brief sql server monitoring ways.
Explain about system database?
How to locate and take substrings with charindex() and substring() functions?
Does index slows down insert statements?
How does stuff differ from the replace function?
What is DAC? what is the use of it?
Does group by sort data?
What are ddl (data definition language) statements for tables in ms sql server?
what is a transaction and what are acid properties? : Sql server database administration
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
