select max(sal) from emp where sal !=(select max(sal) from emp);

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

Question Posted / pari

Answer Posted / pari

select max(sal) from emp
where sal !=(select max(sal) from emp);

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is database black box testing?

985

What triggers long term care?

991

What do you understand by integration services in sql server?

922

How can we solve concurrency problems?

995

List some of the rules that apply to creating and using a ‘view’

817

What is the openxml statement in sql server?

1012

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1049

What is db stored procedure?

816

What do you understand by intent locks?

956

How to change the system date and time from SQL Plus Terminal ?

1154

What is resource db in sql server?

967

What happens if null values are involved in comparison operations?

910

Which tcl commands are available on the sql server?

1018

what do you understand by change data capture?

940

Explain the concepts and capabilities of sql server?

923