select * from emp_record e1 where (3-1) = (select count ( distinct

find out the third highest salary?

Question Posted / punit chauhan

Answer Posted / punit chauhan

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

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is oracle the best database?

915

What are advantages of dateset in datastage?

2202

Explain an exception and its types?

1012

What happens if variable names collide with table/column names?

1105

What are privileges and grants?

1002

What is a static data dictionary in oracle?

1025

What are the oracle built-in data types?

1011

What is blob data type in oracle?

1049

What is transaction control statement and how many types of transaction control statement in Oracle?

1080

How do I limit the number of rows returned by an oracle query after ordering?

1102

How to use in conditions in oracle?

998

How will you identify oracle database software release?

944

Explain the use of show option in imp command.

1049

What are the different oracle database objects?

1032

What happens to the indexes if a table is recovered?

944