SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC )

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

Question Posted / yogesh sharma

Answer Posted / yogesh sharma

SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6;

Is This Answer Correct ?

77 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What are pl sql data types?

957

What are all the different normalization?

979

tell me about various levels of constraint. : Sql dba

991

What are the subsets of sql?

1038

What is clustered index in sql?

1003

What is sql*loader and what is it used for?

1047

What are the different dcl commands in sql?

1069

what is a trigger? : Sql dba

976

Is oracel sql developer written in java?

1060

What are the disadvantages of not performing database normalization?

1097

What is the purpose of primary key?

968

How to get help at the sql prompt?

1055

What is sql query limit?

914

How to run sql statements with oracle sql developer?

1000

How can we implement rollback or commit statement in a trigger?

981