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 a tablespace? : Sql dba

1007

What is dynamic query?

917

How can you fetch first 5 characters of the string?

948

What is difference between procedure and trigger?

922

Is grant a ddl statement?

857

define sql update statement ? : Sql dba

1051

What is sqlcommand?

967

what is the difference between truncate and delete statement? : Transact sql

1017

Can a varchar be a primary key?

958

What is package in pl sql with an examples?

976

What is a scalar value in sql?

1014

What is sql data?

925

What are hotfixes and patches?

892

What is a null value?

1089

What is the difference between delete and truncate commands?

982