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

What are user-defined functions (udfs) in sql server?

983

What are the fixed server level roles? : sql server security

1119

What are indexers?

1084

What is ddl command?

967

What is a performance monitor?

969

What are the different types of replication are there in sql server 2000?

1036

What are the commands used in DCL?

1019

What are the reporting services components?

142

Do you know what is openxml in sql server?

1063

Explain log shipping and mention its advantages.

1038

How is table type constraint applied to a table?

973

What is sql server profiler trace data file?

1106

What command must you use to include the not null constraint after a table has already been created?

1140

Explain what are the restrictions while creating batches in sql server?

1061

What is the sql case statement used for? Explain with an example?

990