Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24094 Views
- I also Faced
- E-Mail Answers
Answer Posted / vj
with cte as
(
select dense_rank() over (order by salary desc)
maxSal ,* from Employee )
select * from cte where maxSal=6
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain declarative management framework (dmf) in sql server 2008?
What is sql azure database?
what is the system function to get current user's user id? : Sql server database administration
What is field in algebra?
How can I check that whether automatic statistic update is enabled or not?
What happens if we shrink log file in sql server?
Tell me about joins in database system and explain each in detail.
Can you explain what are various ways to enhance the ssrs report?
Do you know what are various aggregate functions that are available?
Why is normalisation important?
We need to perform what steps in the following order to work with a cursor?
What is the federation in sql azure?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What are relationships and mention different types of relationships in the dbms
What is the use of for clause?
