select ename,sal from emp E where 1=(select count(*) from emp where E.sal&

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

Question Posted / sivashankar.soma

Answer Posted / sivashankar.soma

select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)

Is This Answer Correct ?

16 Yes

29 No

Please Help Members By Posting Answers For Below Questions

How to receive output values from stored procedures?

1236

what are the different types of replication you can set up in sql server? : Sql server database administration

1063

How to get the definition of a user defined function back?

1088

How would you add a section to a table?

1112

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

1000

How will you decide the active and passive nodes?

1182

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1251

What is @@rowcount in sql?

1058

What is query cost in sql server?

1040

Why can there be only one clustered index and not more than one?

1042

What is the difference between mysql and sql server?

1091

Explain trigger and its types?

1116

Can coalesce return null?

1070

application server is slow what may be the problem

2274

How to insert multiple rows with one insert statement in ms sql server?

1181