select * from emp e1 where (3-1) = (select count(distinct (e2.sal)) from e

find out the third highest salary?

Question Posted / sanjeev kumar p

Answer Posted / sanjeev kumar p

select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)

Is This Answer Correct ?

99 Yes

51 No

Please Help Members By Posting Answers For Below Questions

How to create a table interactively?

995

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1894

What is an oracle database table?

958

Explain overloading. Can functions be overloaded?

933

What is a procedure in oracle?

1068

What is ADDM Advisor in Oracle?

1111

Explain the types of exception?

1078

Explain an extent?

1047

How to rename a tablespace in oracle?

1030

1) Does oracle have any table which contain all the exceptions and it's code internally?

1695

Explain table?

1057

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2431

Explain the use of log option in exp command.

1043

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

1003

what happened to the global index when I truncate the data in one of the partition?

1959