select level,max(sal)from af where level=3 connect by prior sal>sal gr

Find out the 3rd highest salary?

Question Posted / suneel

Answer Posted / suneel

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

Is This Answer Correct ?

8 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is dml statement?

961

What are some predefined exceptions in pl/sql?

1171

what is acid property in database? : Sql dba

1032

what are the different type of sql's statements ? : Sql dba

926

What is parallel hint?

1330

Show the cursor attributes of pl/sql.

1050

How to pipe multiline string to isql?

1008

Explain polymorphism in pl/sql.

1123

how is exception handling handled in mysql? : Sql dba

1084

Can we join more than 2 tables in sql?

1024

Why do we use %rowtype & %type in plsql?

1053

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1027

How do I install microsoft sql?

1055

Which table is left in join?

983

Does postgresql run on the cloud?

1152