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 a scheduled jobs or what is a scheduled tasks? : Sql dba

554

can a stored procedure call itself or recursive stored procedure? : Sql dba

581

Is it possible to update views?

542

How many sql core licenses do I need?

509

How to call a javascript function from pl sql?

565

Mention what is the plv (pl/vision) package offers?

641

What is left join in sql?

584

what are dynamic queries in t-sql? : Transact sql

563

explain the difference between myisam static and myisam dynamic. : Sql dba

519

What is java sql drivermanager?

551

What is coalesce in sql?

563

What is foreign key and example?

518

Is progress software supports to ( pl/sql )?

530

how to select first 5 records from a table? : Sql dba

509

Can a foreign key be a duplicate?

510