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 delete and truncate.

1114

What is shrink log file?

953

explain the storage models of olap? : Sql server database administration

1016

Explain log shipping and mention its advantages.

1090

Explain error handling in ssis?

1078

Explain about Normalization?

1122

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1127

What are the differences between clustered and non-clustered index?

1080

How self join is different from outer join?

1179

What is database replication? What are the different types of replication you can set up in sql server?

1017

Can the query output be sorted by multiple columns in ms sql server?

1031

How to update a field in SQL after ALTERING a row?

1286

What is the difference between stored procedure and user defined functions?

1238

What are trace flags?

1086

What is ddl command?

1035