select * from (select ID,Salary from employee order by Salary desc) wher

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

Question Posted / kapil singh chauhan

Answer Posted / kapil singh chauhan

select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Do you know what are various aggregate functions that are available?

1215

What is the purpose of a table?

995

What is merge?

1071

Can you type more than one query in the query editor screen at the same time?

1069

How to delete an existing row with delete statements in ms sql server?

1151

Explain full-text indexing?

1045

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8203

If a stored procedure is taking a table data type, how it looks?

6521

Can two tables have the same primary key?

1267

What is explicit mode in sql server?

1109

How connect excel to sql server?

1054

define and explain the differences between clustered and non-clustered indexes.

1253

Explain what are the authentication modes in sql server?

1073

Explain what is meant by replication of database?

1106

What does indexation mean?

1030