select distinct(a.sal) from emp a where &3 = ( select count (distinct(

find out the third highest salary?

Question Posted / saleem

Answer Posted / saleem

select distinct(a.sal) from emp a where &3 = ( select count
(distinct(b.sal) from emp b where a.sal <= b.sal));

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain database link?

1123

How do I uninstall oracle client from windows?

1010

How to call a stored function with parameters?

1045

How to lock and unlock a user account in oracle?

1106

does the query needs a hint to access a materialized view?

1857

How do you find current date and time in oracle?

1047

How to drop an index?

959

How to change system global area (sga) in oracle?

1013

How to convert csv to table in oracle?

990

What happens if you lost a data file?

1034

What are the oracle built-in data types?

1065

Does facebook use oracle?

1031

Why oracle is used?

1058

How to use "for" statements in oracle?

1074

How to connect to the server with user account: sys?

1019