write query for fourth maximum salary from employee table

Answer Posted / yogendra barode

Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you make an attribute not process? : sql server analysis services, ssas

753


what are different types of raid configurations? : Sql server database administration

701


What is user defined stored procedures?

718


what is a self join? Explain it with an example? : Sql server database administration

651


what is unique and xaml nonclustered index

776






What is the difference between web edition and business edition?

103


What are a scheduled jobs?

699


What are cursors stored procedures and triggers?

684


What is primary key and example?

700


Name some of the open source software that you can use in alternative to SSR?

134


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

709


What is a derived table?

703


What is the most common trace flags used with sql server?

684


Explain syntax for dropping triggers?

701


What are the types of lock supported by ?

783