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

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1032

What are the database roles? : sql server security

1108

How can a user-defined datatype be created?

954

What are the main sources of data?

1056

Explain nested trigger in sql?

1024

What is the use of sql profiler in sql server 2012?

856

What is trigger in salesforce?

924

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1025

What is scan table/view and seek table/view when its occurs? : sql server database administration

1009

What is tabulation?

911

Why we should not use triggers?

936

How to call stored procedure using http soap?

1025

What is data source object?

971

Do you have any idea about the tcl commands?

930

When columns are added to existing tables, what do they initially contain?

997