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

Can you have more than one trigger on a table?

1003

Can one improve the performance of sql*loader? : aql loader

1048

What does the file extension accdb stand for?

972

What is date functions?

1030

Why is nosql good?

1025

Can we create table in function?

965

Does postgresql run on the cloud?

1151

How do I run a program in pl sql?

1004

What is user defined functions?

984

How to test for null values?

1052

What is difference between pls_integer and integer?

964

What are pl sql procedures?

1026

Does inner join remove duplicates?

943

Why do we go for stored procedures?

1057

what is online transaction processing (oltp)? : Sql dba

994