select salary from(select salary from emp order by salary desc)where rown

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

Question Posted / manjunath u

Answer Posted / manjunath u

select salary from(select salary from emp order by salary
desc)where rownum<=5;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is normalization sql?

1066

What is the size of partition table?

1049

Differentiate between syntax and runtime errors.

1197

how to escape special characters in sql statements? : Sql dba

1045

What is the difference between functions, procedures, and packages in pl/sql?

1060

What is acid property in a database?

1041

How would you reference column values before and after you have inserted and deleted triggers?

1071

How to prepare for oracle pl sql certification?

1075

What are the basic sql commands?

1098

Why do we go for stored procedures?

1066

How bulk collect improves performance?

1014

what is table? : Sql dba

1071

Does sql*plus also have a pl/sql engine?

1087

How to move files from one directory to another in pl sql?

1200

What is a sql statement?

975