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

Is merge a dml statement?

1029

How do I run a pl sql program?

1191

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2205

What are hotfixes and patches?

986

What is difference between stored procedure and trigger?

1251

Explain the difference between triggers and constraints?

1025

What is difference between cursor and trigger?

1129

Define implicit and explicit cursors.

1206

What is the usage of sql functions?

1204

Which are sql * plus commands?

1202

Can you sum a count in sql?

1061

What is meant by truncate in sql?

1109

Can we use insert statement in function?

1047

Explain what is a database?

1136

What is audit logout in sql profiler?

1073