Interested to Buy Any Domain ? << Click Here >> for more details...
Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 25624 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / rakhi
Select Salary From [TableNAme] WHERE Salary IN(Select Top
Nth Salary From [TableName] ORDER BY Salary DESC) ORDER BY
DESC
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is create statement?
What is a periodical index?
Can you explain powershell included in sql server 2008?
How to execute a stored procedure in ms sql server?
Explain the usage of floor function in sql server.
When to use null data driven subscription?
What are the types of subscriptions in SQL Server replication?
List the different types of joins?
How does Report Builder support Analysis Services cubes?
What do you mean by subquery?
What is relationship? What number of sorts of relationship are there?
List all types of constraints in sql server?
How do you size a resultset?
Mention the command used to rename the database.
