Select sal from emp order by desc fetch first 3 rows only;

a query to select maxmun 3 salaries of employee table

Question Posted / chaitanya

Answer Posted / chaitanya

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to view the tablespaces in the current database?

566

What is difference between sid and service name in oracle?

525

What are the different oracle database objects?

594

Does oracle database need java?

535

Hi Can any one tell me what are the API's used in requisition import.

1506

What privilege is needed for a user to insert rows to tables in another schema?

574

What is the implicit cursor in oracle?

584

How is it different from a normal table?

589

What is the order of defining local variables and sub procedures/functions?

612

How to select an oracle system id (sid)?

599

What privilege is needed for a user to create views in oracle?

603

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1741

Can a formula column be obtained through a select statement ?

1853

What are the execution control statements?

629

How a tablespace is related to data files?

589