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

Can sql server 2016 run on windows 7?

963

What do you mean by sql server 2005 express management tools?

1350

Explain multiserver query

1108

Explain the dirty pages?

1050

What are the properties of the transactions?

1167

Explain the properties of sub-query in sql server?

1066

Why we need to use secondry database file? though, we can do same work using primary database file also.

7005

What are the difference between primary keys and foreign keys?

1010

How to start sql server browser service?

1177

difference between Clustered index and non clustered index ?

1030

When would you use it?

1040

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1067

What is normalization of database? What are its benefits?

1070

Explain following error properties?

1058

How will you make an attribute not process? : sql server analysis services, ssas

1157