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

When can we use the where clause and the having clause?

1020

what is subquery? : Sql dba

1139

what are the disadvantages of mysql? : Sql dba

1149

Can I create table without primary key?

1002

What are the subsets of sql?

1136

What is difference between group by and partition by?

1062

Mention what does the hierarchical profiler does?

1093

Explain how can you save or place your msg in a table?

1029

What is an index in sql with example?

976

What is pl sql commands?

1049

What are all the different normalizations?

1036

What is the use of function in sql?

1096

Explain ttitle and btitle.

1123

How do I count records in sql?

1014

Name some usages of database trigger?

1021