select max(salary) from emp where sal<(select max(salary) from emp

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

Question Posted / girish

Answer Posted / girish

select max(salary) from emp where sal<(select max(salary)
from emp

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the filtered indexes?

976

Detail about the hardware which is supported by SQL server?

1009

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

912

How many types of keys are there?

964

How to start sql server browser service?

1066

Can we deploy SSRS reports on our personal website?

162

What is federation member?

114

Create and insert into temp table in sql server?

977

Explain insert into select statement?

899

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

1015

Explain microsoft sql server functions?

1034

What are 3 ways to get a count of the number of records in a table?

1017

What are the advantages of policy management?

942

What is the contrast between sql and mysql?

1049

What kind of problems occurs if we do not implement proper locking strategy?

1356