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

36 Answers
73977 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to check table values in sql server?

952

tell me the disaster recovery plan

2511

Why is replication required on the sql server?

1056

Explain how dts is used to extract, transform and consolidate data?

987

How many types of database relationship in sql server?

1050

How to perform key word search in tables?

956

What is Federation and Federation Member?

What are the differences between stored procedure and view in sql server?

1240

What is dbcc command in sql server?

1086

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1846

What factors you will consider calculating the storage requirement for that view?

940

what is a traditional network library for sql servers? : Sql server database administration

947

What are click through reports?

142

How much does sql server 2016 cost?

1057

Why should you use or avoid select * statements?

1020