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

36 Answers
74146 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

959

You want to implement the many-to-many relationship while designing tables. How would you do it?

999

What is database mirroring?

1118

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

Define indexes?

1045

Explain primary key and foreign key constraints?

1032

What is factless fact table? : sql server analysis services, ssas

1031

What is Dependency Injection and provide example?

1118

Explain relational data?

927

what type of index will get created after executing the above statement? : Sql server database administration

976

Can we install sql server 2016 on windows 7?

1135

How to scale out a federation by Sql statement?

116

What is the difference between indexing and hashing?

1169

Explain can SSRS reports Cache results?

158

What is the purpose of indexing?

1046