select * from emp e1 where 2 = ( select count(distinct sal)

how to get second highest salary in SQL(as/4000

Question Posted / raji_4u

Answer Posted / raji_4u

select *
from emp e1
where 2 = ( select count(distinct sal)
from emp e2
where e1.sal <= e2.sal
)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can you join views in sql?

994

What are the features of pl sql?

1108

How do I remove sql developer from windows 10?

1178

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1061

what is recursive stored procedure? : Sql dba

1026

What is the usage of distinct keyword?

1111

what are numeric data types? : Sql dba

1108

Is not null in sql?

1041

how to convert numeric values to character strings? : Sql dba

1154

Can we use the cursor's to create the collection in PL/SQL?

1090

How to set up sql*plus output format in oracle?

1078

how does a local variable is defined using t-sql? : Transact sql

1057

What is a rank in sql?

1004

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1046

Explain the uses of control file.

1098