Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25071 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / ricky
select min(salary) from tablename where salary is(select
top n salary from tablename order by salary desc)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is transaction server auto commit?
Explain primary key in sql server?
How to use “drop” keyword in sql server and give an example?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can two different columns be merged into single column? Show practically?
What is the need for group functions in sql?
Where are SQL server users names and passwords are stored in sql server?
Define master database?
What is sql server profiler trace data file?
What does the on update no action do?
What are the main sources of data?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Explain the collation?
