Find top Nth employee from each department in terms of
salary?
Answer Posted / madhu
select top 1 salary,employee from (table name) group by
department
| Is This Answer Correct ? | 10 Yes | 13 No |
Post New Answer View All Answers
What are the restrictions applicable while creating views? : SQL Server Architecture
How to include date and time values in sql statements?
Write the SQL query to drop, truncate and delete table.
what are triggers? : Sql server database administration
Explain the use of keyword with encryption. Create a store procedure with encryption?
What are the differences between decimal and float in ms sql server?
What is equi join with example?
How ssrs maintain security?
What is the architecture of ms sql reporting service?
What are the disadvantages of indexes?
How to test values returned by a subquery with the in operator?
What are a database and a data warehouse?
What is bit data type?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What are trace flags and mention a few common trace flags used with sql server?