select * from emp e where 2>(select count(esal) from emp where e.esal&

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

Question Posted / krishna

Answer Posted / krishna

select * from emp e where 2>(select count(esal) from emp
where e.esal<=esal)

Is This Answer Correct ?

3 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the maximum size of column in sql server?

893

How sql server executes a statement with nested subqueries?

1030

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148

Explain the stored procedure?

1054

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

What is the sql case statement used for?

1100

What does it mean to normalize data?

943

How will you optimize a stored procedure optimization?

1041

can a table be moved to different filegroup? : Sql server administration

979

Is a primary key unique?

992

Can binary strings be used in arithmetical operations?

937

Define ACID properties in a Database?

1058

What is TDS(Tabular Data Stream) Gateway?

121

Explain the purpose of indexes?

977

How to create new tables with "select ... Into" statements in ms sql server?

991