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

How to concatenate two character strings together?

1058

Write an sql query to find first weekday of the month?

867

How to access the deleted record of an event?

978

What are scalar functions?

949

What are cursors in ms sql server?

1111

How can I get data from a database on another server?

935

Explain what are the basic functions for master, msdb, model, tempdb databases?

913

How to fine-tune reports?

247

How will you monitor replication latency in transactional replication? : sql server replication

1089

What is dknf in normalization form?

987

What is self contained multi valued query?

951

What do you mean by tablesample?

1035

which table keeps the locking information? : Sql server administration

1013

What are a scheduled jobs or what is a scheduled tasks?

849

List out the differences between the clustered index and non-clustered index in sql server?

947