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

What is the use of %rowtype?

1025

Do prepared statements prevent sql injection?

934

how do you know if your mysql server is alive? : Sql dba

1063

How to run sql statements through the web interface?

1021

What are the types of optimization?

932

What is the use of double ampersand (&&) in sql queries? Give an example

1122

What is crud stand for?

985

What are hotfixes and patches?

931

what are enums used for in mysql? : Sql dba

1158

Explain two easy sql optimizations.

995

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1427

Explain how exception handling is done in advance pl/sql?

986

What is %rowtype in pl sql?

975

Are left and right joins the same?

1055

What is a system versioned table?

961