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 sql analyzer?

1026

What do you understand by exception handling in pl/sql?

1036

What is range partitioning?

972

What are the sql commands?

1185

Which are the different case manipulation functions in sql?

1028

How to run pl sql program in mysql?

1025

What schema means?

892

Can there be more than one function with a similar name in a pl/sql block?

986

what is msql? : Sql dba

994

Why do we use joins?

1044

Define commit?

1009

What are basic techniques of indexing?

1386

How to run sql statements through the web interface?

1047

What is pl sql quora?

1174

What is out parameter used for eventhough return statement can also be used in pl/sql?

1082