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


Please Help Members By Posting Answers For Below Questions

Describe how to use linked server?

689


What do you mean by 'normalization'?

784


What is side by side migration in sql server?

745


How do I debug a stored procedure in sql server?

726


is it important for a database administrator to understand the operating system and file access? : Sql server administration

776






What is difference between temp table and cte?

717


How to apply cascading referential integrity in place of triggers?

743


How is foreign key related to primary key?

716


How to create a new login name in ms sql server?

703


What is Cross Join and in which scenario do we use Cross Join?

772


Which Model uses the SET concept

745


Difference between uniqe index and uniqe constraint?

716


How to create user defined functions with parameters?

840


How to use old values to define new values in update statements in ms sql server?

868


explain different types of backups avaialabe in sql server? : Sql server database administration

752