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 types of replication are supported in sql server? : Sql server database administration

954

Please explain what is “asynchronous” communication in sql server service broker?

879

What is the return type of executeupdate ()?

858

Which is the latest version of sql server and when it is released?

1028

how to trace the traffic hitting a sql server? : Sql server database administration

1771

Does any body please help me what question's have asked for SSRS in the interview?

2086

What is the use of “join” in sql server?

1018

How to find which stored procedure is currently running in sql server?

925

What are the two authentication modes in sql server?

1058

How do I find the query plan in sql server?

908

What are acid properties of transaction?

894

What is indexing and its types?

963

What is temporary stored procedure?

896

Explain various On-Delete options in a DB table. Which is the default option?

1404

Mention what are the different types of ssrs reports?

144