select employee_id,last_name,salary from employees where rownum <=3 o

how to retrieve the top 3 salaries of the table using rownum

Question Posted / kavitha

Answer Posted / kavitha

select employee_id,last_name,salary
from employees
where rownum <=3
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between the conventional and direct path loads? : aql loader

1318

What is the purpose of a sql?

915

What are field types?

942

How to download oracle sql developer?

1058

Are there any features that are decommissioned in 11g that are not present in 11g?

2069

What is embedded sql with example?

989

explain the options of myisamchk to improve the performance of a table. : Sql dba

954

What is the usage of nvl function?

984

What are the various restrictions imposed on view in terms of dml?

911

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1117

How do I run pl sql in sql developer?

1063

Why partition by is used in sql?

972

What are the qualities of 2nf?

975

Which is faster union or join?

903

How do I view a view in sql?

890