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

List the various oracle database objects?

1055

What are the common oracle dba tasks?

1145

What is the difference between alert log file and tarce file ?

2167

Can the query output be sorted by multiple columns in oracle?

992

Difference between inner join vs where ?

1033

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

What are the different pseudo commands? Explain in general?

1074

What is Undo Management Advisor in Oracle?

1095

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1930

Explain the use of parfile option in exp command.

1067

How to create a stored function in oracle?

1105

Can you create a synonym without having a table?

1040

What are the arithmetic operations?

1084

How to connect to a remote server?

1124

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

953