Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24425 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
What is 5nf in normalization form?
what is an index? : Sql server database administration
What is multi-statement table-value user-defined function?
What is the difference between implicit and explicit transaction?
what is the difference between count(*) and count(1) ?
Explain the flow of creating a cube? : sql server analysis services, ssas
What do you mean by an execution plan? How would you view it?
What is database isolation in sql server? : sql server database administration
What is query parameter in ssrs?
Can you please explain the difference between primary keys and foreign keys?
Do you know what are the steps to process a single select statement?
Tell me the difference between clustered and non-clustered index?
What do you understand by sql server agent?
Explain different forms of normalization?
How you can minimize the deadlock situation?
