select * from emp e where 2>(select count(esal) from emp where e.esal&

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

Question Posted / krishna

Answer Posted / krishna

select * from emp e where 2>(select count(esal) from emp
where e.esal<=esal)

Is This Answer Correct ?

3 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is function of master database?

What is cross join in sql server joins?

612

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

758

Can we insert data into view sql server?

522

How to scale out a federation by Sql statement?

What is 2nf example?

558

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

539

What is table level trigger?

594

What is sql server transaction log file?

528

What is efficiency data?

527

What type of locking occurs during the snapshot generation? : sql server replication

874

Why would you use sql agent?

740

How to create “dependant” parameter “make, model, year”

What is the current limitation of the size of SQL Azure DB?

102

How to perform key word search in tables?

540