select e1.sal from emp e1 where 2=(select count(distnct (e2.sal) from emp

write the query for find the top 2 highest salary in sql
server

Question Posted / srinivas

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

Please Help Members By Posting Answers For Below Questions

How do I view a trc file?

975

Difference between report and query parameter. Why do we need different type of parameter?

1004

What are the general features of sql server management studio? : sql server management studio

1126

What is @@rowcount in sql?

1055

What is a constant or literal in ms sql server?

1096

What is forward - only cursors / read only cursor?

1128

How to delete a database in ms sql server?

1313

When is the use of update_statistics command?

1055

ow to bring suspect mode datbase online from scratch

1854

How can a database be repaired?

1031

Define tool Manage Statistics in SQL Server 2000 query ?

1163

How to restore performance issues and how to check?

2050

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1242

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1055

Is t sql the same as sql server?

1019