Find top Nth employee from each department in terms of
salary?
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 are recommended options to be used while using db mirroring? : sql server database administration
Explain about merge replications?
Do you know what is rank function?
What objects does the fn_my_permissions function reports on? : sql server security
What is model database in sql server?
what is raid? : Sql server database administration
Differentiate between ms sql server reporting services vs crystal reports?
What is conditional split?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain what role entity and relationship play in an ER diagram.
What stored by the model?
How to select some specific rows from a table in ms sql server?
How many null values we can have in a unique key field in sql server?
What is a trace frag?