Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24517 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,
salary
from
employee
) a
where
rnk = 4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between LEN() and DATALENGTH() in sql server ?
How to retrieve field values using mssql_result()?
What is standby servers? Explain types of standby servers.
What part does database design plays a role in performance of an sql server-based application?
How can you list all the table constraints in a database?
What does it mean to normalize a database and why would you do it?
Why we use the openxml clause?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
what is sql server? : Sql server database administration
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How do you open a cluster administrator?
How to rebuild indexes with alter index ... Rebuild?
What are the types of containers in ssis?
what is the different types of backups available in sql server? : Sql server database administration
