select max(sal) from emp where sal<(select max(sal) from emp)

how to get second highest sal of emp table

Question Posted / yadunandan

Answer Posted / yadunandan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1096

Hi Can any one tell me what are the API's used in requisition import.

1923

How many types of table in Oracle?

1124

Explain oracle left join with an example?

1013

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944

candidate key is subset of super key but not vice-verse explain

2068

Can sub procedure/function be called recursively?

1004

How do you find current date and time in oracle?

1047

What are transaction isolation levels supported by oracle?

1072

What is the data pump import utility?

1035

what is a Nested Loop join?

2117

Explain what are the different type of segments?

966

Explain the use of compress option in exp command.

1021

List the various oracle database objects?

1060

How to grant create session privilege to a user in oracle?

1002