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

What is the difference between a subquery and a join?

1114

What does select count (*) mean in sql?

1022

What is rank () in sql?

952

What is a sql profiler?

1032

Can we use delete in merge statement?

1043

What is the execution plan in sql?

1032

How do I turn a list into a table?

963

Why we use join in sql?

979

Is sql easier than java?

1020

What is string data type in sql?

1149

Explain correlated query work?

1059

Can we join tables without foreign key?

966

what is the syntax used for partition in tsql? : Transact sql

1017

what are the properties and different types of sub-queries? : Sql dba

1036

Are stored procedures faster than dynamic sql?

1047