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

What are the types of trigger in oracle?

978

How to connect asp pages to oracle servers?

1072

interview questions with answer for cts

2579

How to create a table in a specific tablespace?

974

What is bulk collect in oracle?

996

How do I manually uninstall oracle client?

1083

What is recovery manager in Oracle?

1054

How to view the data files in the current database?

1096

How to write text literals in oracle?

1066

What is the minimum client footprint required to connect c# to an oracle database?

1092

Explain what are the different type of segments?

965

How to view the tablespaces in the current database?

978

Does facebook use oracle?

1031

What is a view and how is it different from a table?

1044

Can you have more than one content canvas view attached with a window ?

2333