write query for fourth maximum salary from employee table
Answer Posted / anish tuladhar
select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
salary
from
employee
) a
where
rnk = 4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a schema in sql server 2005? : Sql server database administration
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How many levels of sp nesting is possible?
What is explicit mode in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain “row_number()” in sql server with an example?
What are the requirements for sql server 2016?
What is side by side migration in sql server?
What are the advantages of using a stored procedure?
where can you add custom error messages to sql server? : Sql server administration
Explain primary key, foreign key and unique key?
How do I start and stop sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
Tell about MOM Tool(Microsoft Operator Manager)?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration