Guys See the correct answer. select distinct sal from emp a where 4 =

find out the third highest salary?

Question Posted / sam

Answer Posted / sam

Guys
See the correct answer.

select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Define oracle database

1041

How to change user password in oracle?

1025

What is tns entry?

1147

What is the maximum number of triggers that can be applied to a single table?

1021

How many types of tables are there in oracle?

1061

How to check the oracle tns settings?

1045

How to start a new transaction in oracle?

1086

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

How to sort output in descending order in oracle?

1043

What is an oracle?

1010

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344

How can we find out the current date and time in oracle?

1088

Can a formula column referred to columns in higher group ?

2501

Explain the importance of .pll extension in oracle?

1008

How do we represent comments in oracle?

1046