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

find out the third highest salary?

Question Posted / sukanya

Answer Posted / sukanya

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between data migration and production migration.

2344

How do I limit the number of oracle database connections generated by weblogic server?

1070

How does Oracle guarantee data integrity of data changes?

2386

Explain alias?

1145

Explain the difference between sql and oracle?

1075

What are the ansi data types supported in oracle?

946

How to delete an existing row from a table in oracle?

1070

How to get execution statistics reports on query statements?

1090

How will you differentiate between varchar & varchar2?

1041

How can you merge two tables in oracle?

998

What are the execution control statements in oracle?

1092

definition of cluster and non-clustered index?

3033

How to execute a stored program unit?

1074

What is a synonym? What are its various types?

1108

How do I connect to oracle database?

1115