SELECT DISTINCT SAL FROM EMP E1 WHERE 2=(SELECT COUNT(DISTINCT SAL) FROM E

find out the second highest salary?

Question Posted / asit kumar sahu

Answer Posted / asit kumar sahu

SELECT DISTINCT SAL FROM EMP E1
WHERE 2=(SELECT COUNT(DISTINCT SAL) FROM EMP E2
WHERE E1.SAL <= E2.SAL);

OUTPUT= 3000

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use regular expression in pattern match conditions in oracle?

1041

What is logical backup in oracle?

1019

How many categories of data types in oracle?

1030

What is the scope of a local variable?

1067

Give the advantages and disadvantages of clusters.

1052

what is difference between sql plus and sql*plus? (not sql and sql plus).

3904

What is the usage of synonyms?

1144

how to handle exceptions in post production

1429

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

What is recovery manager(rman) backup in Oracle?

1185

What are the extensions used by oracle reports?

1039

How to create a new tablespace in oracle?

988

How to connect the oracle server as sysdba?

1079

Can we write dml statement in function in oracle?

1087

Why does oracle 9i treat an empty string as null?

1060