select max(sal) from emp where sal=(select max(sal) from emp where sal<

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

Question Posted / vijayalaxmi m khot

Answer Posted / vijayalaxmi m khot

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

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What authentication modes does sql server support?

758

Explain the difference between function and stored procedure?

683

Is sql server difficult to learn?

691

What is merge?

745

Define magic tables in sql server?

758

What is database white box testing?

846

How to find table changes in sql server?

827

Explain having clause and where clause?

788

What is a fan-out query in SQL Azure?

115

What is report subscription?

109

what are cursors? : Sql server database administration

725

How many types of attribute relationships are there? : sql server analysis services, ssas

776

What is the command used to check locks in microsoft sql server?

726

How to Update from select query in sql server?

737

List all types of constraints in sql server?

685