select sal from emp where sal=(select min(sal) from emp where sal>(sel

find out the third highest salary?

Question Posted / ashutosh pandey

Answer Posted / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

Is This Answer Correct ?

69 Yes

204 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to create views in oracle?

1047

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

1033

What are the different types of failures that occur in Oracle database?

1067

Explain oracle insert into command?

1112

What is oracle database client?

1032

Explain what are the type of synonyms?

1112

How to create a new table in oracle?

1156

How to bring a tablespace offline?

1064

what is the use of system.effective.date variable in oracle?

1116

Write a trigger example in oracle?

1063

What is sharded cluster?

1015

What is oracle rownum?

952

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

1068

Why is oracle so popular?

997

How to check database size in Oracle?

1191