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

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

Question Posted / k.elumalai

Answer Posted / k.elumalai

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

Is This Answer Correct ?

6 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Why we need to use secondry database file? though, we can do same work using primary database file also.

7001

What is sub query and its properties?

1021

What is user-defined function?

1030

How to get all stored procedures in sql server?

1055

List the different index configurations possible for a table?

975

What does sql server mean?

1155

What are the different types of triggers in SQL SERVER?

1183

What happens when transaction log is full?

983

What is buffer cash in sql server?

1199

How do I create a stored procedure in sql server?

1090

Explain view in sql server?

1084

What do you mean by a Composite primary key?

1182

What are acid properties of transaction?

992

How to list all stored procedures in the current database using ms sql server?

1186

What functions can a view be used to performed?

1110