write query for fourth maximum salary from employee table
Answer Posted / ilgian
select min(salary)
from (
select top 4 *
from employees
order by salary desc
) as a
Is This Answer Correct ? | 24 Yes | 7 No |
Post New Answer View All Answers
Can we check locks in database? If so, how can we do this lock check?
What is collation sensitivity? Explain different types.
Explain try...catch with sql server?
How do you start single user mode in clustered installations?
What is the new security features added in sql server 2016? : sql server security
Do you know how to store and query spatial data?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain insert into select statement?
Explain about system database?
Do you know what are the differences between lost updates and uncommitted dependencies?
How to store and query spatial data?
What is de-normalization and what are some of the examples of it?
what is the difference between Tabular and Matrix report?
How to delete duplicate records based on single column from a table?