SELECT Rownum,emp-name,salary FROM(SELECT emp

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

Question Posted / priya

Answer Posted / priya

SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;

Is This Answer Correct ?

17 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which data dictionary views have the information on the triggers that are available in the database?

1240

Can pl sql procedure have a return statement?

1033

what is datawarehouse? : Sql dba

1024

What are operators available in sql?

1051

explain normalization concept? : Sql dba

1052

Why sql query is slow?

1004

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1116

Can we join tables without foreign key?

965

Does pdo prevent sql injection?

935

Which one is faster ienumerable or iqueryable?

937

What is on delete set null?

1092

what is isam? : Sql dba

1015

What are the advantages of sql?

1055

What is a primary key example?

965

Is sql developer case sensitive?

1003