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

How do I enable sql encryption?

969

How to write html code in pl sql?

1059

What is clause?

1067

What is scalar function in sql?

979

How do you take the union of two tables in sql?

934

How to add, remove, modify users using sql?

980

what does myisamchk do? : Sql dba

963

What is the difference between microsoft sql and mysql?

921

What are the different types of dbmss?

965

What is native sql query?

972

What are pl sql data types?

956

What is user in sql?

970

what does it mean to have quoted_identifier on? : Sql dba

1101

How many sql commands are there?

1073

What are all types of user defined functions?

1006