select e1.sal from emp e1 where 2=(select count(distnct (e2.sal) from emp

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

Question Posted / srinivas

Answer Posted / srinivas

select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)

Is This Answer Correct ?

33 Yes

32 No

Please Help Members By Posting Answers For Below Questions

What are the disadvantages of using querystrings to send data from one page to another?

1071

What is sub-query in sql server?

1259

When to use Inner join & when to use subquery?

1237

What is an indice?

1085

Explain the commands in sql server?

1096

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1180

Which is the main third-party tool used in sql server?

993

What is the use of sign function?

1196

Explain trigger and trigger types?

1036

Write a query for primary key constraint with identity key word?

1080

Define synonym?

1222

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1200

Do you know what are the properties of the relational tables?

1067

Why truncate is ddl command?

1116

How to provide login information for a new odbc dsn?

1094