select level,max(sal) from table where level=3 connect by prior sal>s

find the third highest salary?

Question Posted / purushotham

Answer Posted / purushotham

select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain normalization and what are the advantages of it?

518

What is pl sql in oracle?

585

What is sequence in sql?

509

what are the advantages and disadvantages of cascading style sheets? : Sql dba

555

Enlist the data types that can be used in pl/sql?

577

what is not null constraint? : Sql dba

553

what are the types of join and explain each? : Sql dba

534

What does <> sql mean?

542

What is t sql in sql server?

572

Does sap use sql?

519

how many ways we can we find the current date using mysql? : Sql dba

619

What is pivot in sql?

512

Is postgresql a server?

577

How to fix oracle error ora-00942: table or view does not exist

571

what is offset-fetch filter in tsql? : Transact sql

539