Select TOP 1 salary from (select Distinct TOP 2 salary from employee orde

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / amitkumar

Answer Posted / amitkumar

Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How will you differentiate between varchar & varchar2?

1048

How to convert characters to dates in oracle?

1104

How to run the anonymous block again?

1135

What are the built-in functions used for sending Parameters to forms ?

3391

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2052

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

1926

How to define a sub function?

1139

Respected sir, Please send me technical questions related to oracle apps..

1815

How to rename an existing table?

1130

Explain the use of grant option in imp command.

1033

Explain rename?

988

What is an oracle wallet?

945

How to resolve the ORA-39133 error in Oracle?

1126

What is a cursor and what are the steps need to be taken?

1205

how do u setup a replication site?

1992