How to find 6th highest salary from Employee table ?
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
how to create “alternate row colour”?
What is dbcc?
How to create a view using data from another view?
What is difference between line feed ( ) and carriage return ( )?
explain different levels of normalization? : Sql server database administration
How to generate create view script on an existing view?
What is the difference between dropping a database and taking a database offline?
what is blocking? : Sql server database administration
Explain tablesample?
SQL Server Architecture ?
How to create an multi-statement table-valued function?
How to throw custom exception in Stored Procedure?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can sql server be linked with other servers like oracle?
How do I get to sql server configuration manager?