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

what is the difference between substr and instr function in oracle?

1086

Explain parameter file in oracle.

1027

What is catalog in Oracle?

1362

How to delete an existing row from a table in oracle?

1070

How to calculate date and time differences in oracle?

1039

How to export data to a csv file?

1301

Explain a segment?

1083

How to initialize variables with default values?

1239

How to create a new user account in oracle?

1020

How to run create database statement again?

1154

What is an oracle?

1010

What is parameterized cursor in oracle?

1148

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2310

How to convert characters to numbers in oracle?

1065

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

971