select level,max(salary) from employee where level=3 connect by prior sal

how to check the 3rd max salary from an employee table?

Question Posted / kotesh

Answer Posted / kotesh

select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can primary key be changed?

952

Is join an inner join?

1022

Is oracle sql free?

1037

What is pragma in sql?

1125

what is union, minus and interact commands? : Sql dba

1254

is it possible to pass an object or table to a procedure as an argument?

1177

Is id a reserved word in sql?

1187

What is compilation error in pl sql?

1024

What does over partition by mean in sql?

1040

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1149

How to start oracle sql developer?

1074

What is difference between table and view?

1135

Why functions are used in sql?

1042

Explain unique key in sql.

1060

What is java sql package?

1143