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,
modelyr_id_int
from
employee
) a
where
rnk = 4
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is msdb database? : SQL Server Architecture
Explain how would you store your query in an SSRS report or a Database server?
What do you mean by data integrity?
How to store and query spatial data?
How to choose all records from the table?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What are the purposes of floor and sign functions?
What is log shipping?
How to use linked server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the difference between web edition and business edition?
What is acid properties?
Which data type columns are the best candidates for full-text indexing?
What is postgresql server?