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 to test values returned by a subquery with the in operator?
What is purpose of normalization?
What are triggers in ms sql server?
What is xdr?
Can binary strings be converted into numeric or float data types?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What are the requirements to use odbc connections in php scripts?
How to get a list all databases on the sql server?
What is shared lock?
What are the underflow and overflow behaviors on float literals?
What do I need to start working with sql studio? : sql server management studio
How do I start sql server 2016?
What is Lock table in SQL?
Write a sql query to get zero records from a table having n number of records?
Explain SSRS Architecture?