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

How do I make sql search faster?

1044

What are sql data types?

1072

what are the types of join and explain each? : Sql dba

1085

What are pl sql data types?

1056

What is embedded sql with example?

1097

what is the difference between delete and truncate statement in sql? : Sql dba

1346

What is database sql?

1097

What is a schema sql?

1225

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1183

What is procedure and function in sql?

1045

I need a function for a train ticket reservation please answer it thanks in advance

1078

What is the difference between having clause and where clause?

1110

Can we join more than 2 tables in sql?

1093

Differentiate between sga and pga.

1206

What is sequence in sql?

1075