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

Find out the 3rd highest salary?

Question Posted / santosh

Answer Posted / santosh

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to write a query to show the details of a student from students table whose

937

What are the types of operators available in sql?

1008

how to create a new view in mysql? : Sql dba

892

How do I create an index in word?

965

what are date and time intervals? : Sql dba

998

what is the difference difference between procedure and packages

10250

What will you get by the cursor attribute sql%notfound?

1011

What are sql constraints?

1124

What does joining a thread mean?

972

What is snowflake sql?

1010

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1088

Is left join faster than join?

982

what is schema? : Sql dba

985

what is sql? : Sql dba

970

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

954