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
151434 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 is an index associated with a constraint?

1040

How to loop through a cursor variable?

1091

Explain the truncate in oracle?

971

Explain a segment?

1093

How to use an explicit cursor without open statements?

1057

What is the order of defining local variables and sub procedures/functions?

1061

What are the oracle differences between nvl and coalesce

1150

What is connection pool in oracle?

992

What is the maximum limit on the number of columns in a table?

1089

How to run create database statement again?

1160

What are the limitations oracle database 10g xe?

1047

How to shutdown your 10g xe server?

1152

What exactly do quotation marks around the table name do?

966

How to define a record variable to store a table row?

1061

How to write a left outer join with the where clause in oracle?

1087