Hi All, This query will give you the o/p. Select * from EMP A where &

find out the third highest salary?

Question Posted / venkatranjith e

92 Answers
153863 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / venkatranjith e

Hi All,

This query will give you the o/p.

Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)

n = 3 , to display 3rd largest salary.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens if the imported table already exists?

1078

How to use subqueries in the from clause in oracle?

1165

Why oracle is used?

1108

How to define an anonymous procedure without variables?

1196

Difference between varchar and varchar2 data types?

1262

Can we use bind variables in oracle stored procedure?

987

Explain the use of analyse option in exp command.

1199

What is integrity and what is constraint??Explain with example

2345

How to convert a string to a date in oracle database?

1102

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2357

How can you merge two tables in oracle?

1049

How to delete a column in an existing table in oracle?

1130

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

What is a proxy class?

1107