select * from emp e where 2=(select count(sal) from emp where e.sal<=sa

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

Question Posted / ramu

Answer Posted / ramu

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

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is data modification?

895

What types of Joins are possible with Sql Server?

1055

How to find out the list schema name and table name for the database?

893

What is database replication?

1071

What is the purpose of update statistics and scope_identity() function?

1046

What are the dmvs? : sql server database administration

1003

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1985

How do I create a trace in sql server?

955

How many full-text indexes can a table have?

924

What are the operating modes in which database mirroring runs?

1022

What is abstracting periodical?

896

How to insert data with null values?

966

How to enforce security in sql server? : sql server security

1039

What do we have to check in database testing?

963

What is a synonym for manipulation?

929