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
How will you make an attribute not process? : sql server analysis services, ssas
what are different types of raid configurations? : Sql server database administration
What is user defined stored procedures?
what is a self join? Explain it with an example? : Sql server database administration
what is unique and xaml nonclustered index
What is the difference between web edition and business edition?
What are a scheduled jobs?
What are cursors stored procedures and triggers?
What is primary key and example?
Name some of the open source software that you can use in alternative to SSR?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is a derived table?
What is the most common trace flags used with sql server?
Explain syntax for dropping triggers?
What are the types of lock supported by ?