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

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1069

What is the best way to do multi-row insert in oracle?

1107

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

How to run create database statement?

1080

What is an oracle user account?

1040

How to do a full database export?

1153

What is the database name in oracle?

1078

What is oracle open database communication (odbc)?

1083

How to retrieve values from data fields in record variables?

1172

How to get execution statistics reports on query statements?

1153

Can we convert a date to char in oracle and if so, what would be the syntax?

1063

20. Using a set operator, display the client number of all clients who have never placed an order.

2246

How to select some rows from a table in oracle?

1127

Is postgres faster than oracle?

1085

How to do paging with oracle?

1050