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 are sql commands?

991

What are some emotional triggers?

964

What are sql ddl commands?

1074

What is primary and foreign key?

1046

How to return multiple rows from the stored procedure?

954

how can you create an empty table from an existing table? : Sql dba

1135

how many sql ddl commands are supported by 'mysql'? : Sql dba

1001

What is pl sql collection?

947

Explain cursor types?

1002

How long it takes to learn pl sql?

996

What does pl sql stand for?

1097

What is the syntax to add a record to a table?

1072

Is sqlite thread safe?

1033

How can you view the errors encountered in a trigger?

946

What is function and procedure?

1017