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 are isolation levels? : Sql server database administration

483

How to drop an existing schema in ms sql server?

580

What happens if we shrink log file in sql server?

504

List the data types available in mssql?

511

What is log in sql server?

580

What is snapshot parameter in ssrs?

109

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2165

What is Sqlpaging in SqlServer 2005 ?

647

Explain what is the purpose of sql profiler in sql server?

536

Explain full-text query in sql server?

524

What is a data collection table?

530

When you should use a low fill factor?

510

How to create function with parameter in sql server?

545

What is the difference between Normalization and De-normalization?

549

ow to bring suspect mode datbase online from scratch

1393