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 the built in functions of sql?

754

What are the rules to be applied to nulls whilst doing comparisons?

980

How do I start pl sql?

666

How does sql developer connect to oracle database?

736

Why do we use procedures in sql?

764

how many sql dml commands are supported by 'mysql'? : Sql dba

788

What is normalization in a database?

844

how to include numeric values in sql statements? : Sql dba

768

What is the difference between microsoft sql and mysql?

709

Explain the the update statement in sql?

769

What is the difference between null value, zero, and blank space?

759

What are the types of triggers in sql?

696

How do I run sql profiler?

759

What are the two types of exceptions in pl/sql?

732

how many ways we can we find the current date using mysql? : Sql dba

807