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 are the attributes that are found in a cursor?

647

What are named parameters?

612

How to define an anonymous procedure without variables?

545

Explain table?

649

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1728

What is flashback in Oracle?

581

How to commit the current transaction in oracle?

576

What is Virtual Private Database in Oracle?

618

Is java required for oracle client?

548

What are the attributes of the cursor?

553

How to use "while" statements in oracle?

733

How do we create privileges in oracle?

586

Can you assign multiple query result rows to a variable?

546

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173

What happens if the imported table already exists?

547