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 do I run a sql trace?

963

Do ddl statements need commit?

975

What are the popular database management systems in the it industry?

1003

What does := mean in pl sql?

1047

what is index? : Sql dba

1010

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What is pivot query?

1082

what is clause? : Sql dba

1066

What are the types of queries in sql?

1087

What are operators available in sql?

1051

What are tables and fields in the database?

1115

What is the main reason behind using an index?

1020

How exception handling is done in advance pl/sql?

985

How can you select unique records from a table?

1085

What is sqlerrd?

971