write query for fourth maximum salary from employee table
Answer Posted / pramod
Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the types of indexes.
Why can there be only one clustered index and not more than one?
How will you add a dimension to cube? : sql server analysis services, ssas
What are the different types of collation sensitivity?
What is create statement?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are relationships and mention different types of relationships in the dbms
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the different acid properties?
Is it possible in sql table to have more than one foreign key?
What are the export options of ssrs?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What command do we use to rename a database?
What are the differences between union, intersect, and minus operators?
Can a unique index be created on a column, which contains null?