select max(salary) as salary1 from employee where salary

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

Question Posted / naren

Answer Posted / naren

select max(salary) as salary1 from employee where salary <
select max(salary) as salary2 from employee

Is This Answer Correct ?

27 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Is sql different from sql server?

1003

explain declarative management framework (dmf) in sql server 2008?

950

What are dml (data manipulation language) statements in ms sql server?

926

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1001

What is resource db in sql server?

967

What are the advantages of using stored procedures?

892

Mention what are the different types of ssrs reports?

144

What are the indexes in sql server?

1026

What is @@rowcount in sql?

953

What is coalesce and check constraint in sql server?

1046

How will you add a dimension to cube? : sql server analysis services, ssas

1013

What the different types of Replication and why are they used?

981

What are the lambda triggers?

857

What is default constraint?

936

What is a view in sql?

930