select salary from employees where rownum<=5 order by salary desc

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

Question Posted / amit bharane

Answer Posted / amit bharane

select salary from employees
where rownum<=5
order by salary desc

Is This Answer Correct ?

3 Yes

22 No

Please Help Members By Posting Answers For Below Questions

What is sqlca in db2?

974

Is coalesce faster than isnull?

969

How does postgresql compare to oracle/db2/ms sql server/informix?

1039

Is sql a programming?

980

Explain two easy sql optimizations.

1019

Does sap use sql?

997

Explain the rollback statement?

1016

Explain what is sql*plus?

1149

What are tables in sql?

1071

Is null operator in sql?

1046

Which query operators in sql is used for pattern matching?

970

How do I count rows in sql query?

998

Can we edit a view in sql?

988

how would concatenate strings in mysql? : Sql dba

1100

Explain sql data types?

1107