write the query for find the top 2 highest salary in sql
server
Answer Posted / srinivas
select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)
| Is This Answer Correct ? | 33 Yes | 32 No |
Post New Answer View All Answers
How do I view a trc file?
Difference between report and query parameter. Why do we need different type of parameter?
What are the general features of sql server management studio? : sql server management studio
What is @@rowcount in sql?
What is a constant or literal in ms sql server?
What is forward - only cursors / read only cursor?
How to delete a database in ms sql server?
When is the use of update_statistics command?
ow to bring suspect mode datbase online from scratch
How can a database be repaired?
Define tool Manage Statistics in SQL Server 2000 query ?
How to restore performance issues and how to check?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Is t sql the same as sql server?