select min(salary) from (select distinct salary from employee

find out the second highest salary?

Question Posted / anitha

Answer Posted / anitha

select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1136

Please explain oracle data types with examples?

1132

What is an oracle table?

1032

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2387

How do I find the database name in oracle?

1089

How to call a sub procedure?

1147

What is the difference between substr & instr functions?

1293

Can we store images in oracle database?

1066

Who developed oracle & when?

1058

What is define in oracle?

1110

How to rebuild an index in oracle?

1069

How to select all columns of all rows from a table in oracle?

1097

Give the constructs of a package, function or a procedure.

1096

How translate command is different from replace?

1141

How to assign a table row to a record variable?

1092