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

What is the usage of control file in oracle?

611

Can we store images in oracle database?

554

Explain oracle’s system global area (sga).

626

How to define a record variable to store a table row?

579

How to call a sub procedure?

564

What is a read write transaction in oracle?

606

What are the different editions of oracle?

592

How to execute a stored procedure in oracle?

620

Explain an index segment?

646

What is the best way to do multi-row insert in oracle?

563

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3831

What is index in Oracle?

594

How to delete an existing row from a table in oracle?

645

Define oracle database

596

How do you tell what your machine name is and what is its IP address?

1516