SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN(SELECT MAX(SALARY) FR

how to select second mauximum value in a given table under salary column

Question Posted / jai

Answer Posted / jai

SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

27 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is materialized view in Oracle?

1044

How to use "startup" command to start default instance?

965

How to pass a parameter to a cursor in oracle?

1108

What is the usage of save points in oracle database?

912

Can a formula column referred to columns in higher group ?

2458

Is truncate autocommit in oracle?

1027

How to change program global area (pga) in oracle?

1034

How can we find out the duplicate values in an oracle table?

997

What happens to the current transaction if the session is ended?

1040

How to see the table columns used in an index?

967

Why do you create or replace procedures rather that drop and recreate.

950

How to use values from other tables in update statements using oracle?

1026

How to store pictures on to the database?

926

How to create a table index?

1064

Â What are the oracle DML commands possible through an update strategy?

1006