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
Explain triggers?
What is a unique index?
How do I setup a sql server database?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is the boxing and unboxing concept in .net?
What is Dependency Injection and provide example?
What is inline table-value user-defined function?
How to create new tables with "create table" statements in ms sql server?
What are translations and its use? : sql server analysis services, ssas
What is checkpoint process in the sql server?
What do you mean by acid?
how to control the amount of free space in your index pages? : Sql server database administration
Define ACID properties in a Database?
What is intellisense?
How to create an identity column?