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
How will you decide the active and passive nodes?
What are the different types of indexes?
what are triggers? : Sql server database administration
How can a database be repaired?
what is database replicaion? : Sql server database administration
How to verify a login name with sqlcmd tool?
Describe in brief system database.
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is coalesce and check constraint in sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to create a simple table to test triggers in ms sql server?
If we delete pack Spec what will be the status of pack Body ?
What is database isolation in sql server? : sql server database administration
Show Practically Sql Server Views are updatable?
What the different components in replication and what is their use?