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
Which table keeps information about stored procedures?
What is log cache in sql server?
How do I setup a local sql server database?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Suggest a method of joining two tables.
how to overcome kernel isssues
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the cpu pressure?
What do you mean by an execution plan? Why is it used? How would you view it?
What are the differences between DDL, DML and DCL in SQL?
What is subquery in sql?
How do I view a script in sql server?
What is report subscription?
please differentiate between delete and truncate?
What are a database and a data warehouse?