select max(sal) from emp where sal !=(select max(sal) from emp);

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

Question Posted / pari

Answer Posted / pari

select max(sal) from emp
where sal !=(select max(sal) from emp);

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Differentiate between ms sql server reporting services vs crystal reports?

505

What is field in algebra?

646

Do you know what are the steps to process a single select statement?

544

What is the difference between ddl,dml and dcl commands?

616

What are the tables in sql?

641

What is store procedure? When do you use?

536

How do I find query history in sql server?

524

How can you manage sql azure security?

How to connect to a sql server using odbc_connect()?

629

Explain about merge replications?

603

What are the options which must be set to allow the usage of optimistic models?

527

Explain temporary table vs table variable by using cursor alternative?

532

What is Sqlpaging in SqlServer 2005 ?

674

Difference between group by clause and having clause in SQL?

576

What is the difference between executequery () and executeupdate ()?

535