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 the difference between Union and Union all. Which is faster.

1357

What is bulk collect in pl sql?

1049

Can we use pl sql in sql server?

1034

Can primary key be changed?

879

What is crud sql?

939

Why procedure is used in sql?

995

What is online transaction processing (oltp)?

975

what is the difference between $message and $$message? : Sql dba

965

how to write date and time literals? : Sql dba

927

Does inner join remove duplicates?

912

Write a sql select query that only returns each name only once from a table?

974

Explain what is sql?

1079

What does the sign mean in sql?

939

What is the mutating table and constraining table?

986

What is the use of count (*) in sql?

1004