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
Describe how to use linked server?
What do you mean by 'normalization'?
What is side by side migration in sql server?
How do I debug a stored procedure in sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is difference between temp table and cte?
How to apply cascading referential integrity in place of triggers?
How is foreign key related to primary key?
How to create a new login name in ms sql server?
What is Cross Join and in which scenario do we use Cross Join?
Which Model uses the SET concept
Difference between uniqe index and uniqe constraint?
How to create user defined functions with parameters?
How to use old values to define new values in update statements in ms sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration