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
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to create new databases with "create database" statements?
what are the different types of replication you can set up in sql server? : Sql server database administration
List out different types of normalizations in sql server and explain each of them?
what is create database syntax? : Sql server database administration
Are connections to sql server encrypted?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Mention the differences between local and global temporary tables.
Explain the functionalities that views support?
How to create a simple user defined function in ms sql server?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is an identity column in insert statements?
What command is used to rename the database?
How do I view a script in sql server?
how would you troubleshoot blocking? : Sql server database administration