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

What is co-related sub query?

994

What do you understand by replication in sql server?

1017

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

902

Can foreign key be deleted?

893

Describe and explain about SQL native client?

1065

Write a code to select distinct records without using the DISTINCT keyword.

1074

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2047

How many tables can be joined in SQL Server?

1030

What are the different authentication modes in sql server? How can it be changed?

1046

How to delete database objects with "drop" statements in ms sql server?

1057

What is rtm version in sql server?

1002

What is the difference between ddl,dml and dcl commands?

1081

Which database stores information about replication?

1016

What do mean by xml datatype?

1035

What is the use of toad or sqldbx.?

1121