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

What happens if null values are involved in bitwise operations?

1080

What is oltp (online transaction processing)?

1058

What is the report builder?

143

Explain about extended stored procedure?

994

What are acid properties of transaction?

996

What is difference between inner join and join?

1096

How will you know when statistics on a table are obsolete?

1129

what exactly sql injuction.how to overcome.....

2596

Explain the cursor lock types?

1099

Do you know what is rank function?

1128

Difference between Inner vs outer joins?

988

What is merge statement?

1135

Explain transaction isolation levels in sql server?

1184

What languages bi uses to achieve the goal?

1051

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1025