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

what is sql server agent? : Sql dba

1030

Are pl sql variables case sensitive?

1000

How long it takes to learn pl sql?

952

How do I quit sql?

900

What is a sql instance vs database?

1038

What is difference between stored function and application function?

1105

Is oracle sql free?

928

how to fetch alternate records from a table? : Sql dba

1053

What are the types of views in sql?

1041

What is sql stand for?

947

What is t sql in sql server?

1003

How do I create a memory optimized filegroup?

906

How can we store rows in PL/SQL using array?

1162

What is the execution plan in sql?

975

How does a self join work?

994