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

Differentiate between sql temp table vs table variable?

834

How to disable a login name in ms sql server?

1063

Can you tell me about the concept of ER diagrams?

1018

How secure is sql server database?

958

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

What do you understand by triggers and mention the different types of it?

882

What is co-related sub query?

978

What do you mean by data integrity?

998

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

884

What are the types of processing and explain each? : sql server analysis services, ssas

1110

Explain different backup plans?

883

what is the difference between Tabular and Matrix report?

160

Explain the Ways to improve the performance of a sql azure database?

Which language rdl files made of?

124

Describe how to use linked server?

937