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 is the purpose of a sql?

527

What are stuff and replace function?

571

How many types of functions are there in sql?

504

What is relationship? How many types of relationship are there?

591

Is inner join faster than left join?

633

How is data stored in sql?

551

What is the difference between an inner join and an outer join?

514

Explain table and field in sql?

581

What is a nested table in word?

532

How many joins in sql?

554

Is it possible to create the following trigger: before or after update trigger for each row?

721

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2569

Which sql statement is used to delete data from a database?

466

explain the difference between delete , truncate and drop commands? : Sql dba

547

Explain the uses of database trigger.

652