write query for fourth maximum salary from employee table
- 14 Answers
- 22014 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / anish tuladhar
select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
modelyr_id_int
from
employee
) a
where
rnk = 4
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Are semicolons required at the end of sql statements in sql server 2005?
What is the difference between row_number and dense_rank?
Why use stored procedures in sql server?
What is create statement?
How to apply cascading referential integrity in place of triggers?
Explain a checkpoint?
What is data source view or dsv? : sql server analysis services, ssas
What are the different types of triggers in SQL SERVER?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is difference in performance between insert top (n) into table and using top with insert?
Explain microsoft sql server functions?
Explain Capacity planning to create a database? and how to monitor it?
Would you store your query in a ssrs report or a database server? State the reason why?
How to create a stored procedure with a statement block in ms sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
