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

What is instead of dml trigger?

1052

What is the significance of master, tempdb and model databases?

1128

What is the maximum rows in sql server table?

961

What are the advantages of using third-party tools?

1035

Differentiate between mongodb vs. Sql server?

1140

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1104

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8201

Can you leave a union at any time?

1106

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1043

Explain what is public role in sql server?

1184

How to enable/disable indexes?

1120

How do I start sql server agent automatically?

1021

What is sql collation?

1262

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1057

What is use of except clause? How does it differ from not in clause?

1064