select level,max(sal) from emp where level<=5 group by level connect

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / vishnu

Answer Posted / vishnu

select level,max(sal) from emp
where level<=5
group by level
connect by prior sal>sal
order by level Asc;

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is 'mysqladmin' in mysql? : Sql dba

972

What is left join in postgresql?

995

How to select unique records from a table?

999

how can we submit a form without a submit button? : Sql dba

917

How does stored procedure reduce network traffic?

966

Explain about various levels of constraint.

884

What is sql entity?

1030

Are sql database names case sensitive?

935

What are different sql data types?

954

What does partition by mean in sql?

908

How to rename a table?

957

what is blob? : Sql dba

1055

What is the difference between left outer join and left join?

943

Which nosql database is best?

924

What makes a good primary key?

980