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

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3561

What is the size of partition table?

1034

Can you have more than one trigger on a table?

991

What happens when a trigger is associated to a view?

900

What is trigger and how to use it in sql?

1013

What is oracle sql called?

908

What do you mean by rowid?

959

What is sql profiling in oracle?

1046

Mention what pl/sql package consists of?

984

What are the methods of filing?

923

What is an example of translating a date into julian format?

1104

What is mdb stand for?

997

What are the sql aggregate functions?

1110

What is a temp table?

1008

Is join and inner join the same?

993