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 a cursor and what are the steps need to be taken?

1290

State the various uses of dbcc command?

1110

Give the constructs of a package, function or a procedure.

1098

How to delete a user account in oracle?

1022

What is truncate oracle?

1016

How to retrieve data from an explicit cursor?

1109

What is set operator oracle?

1036

What are set operators?

1144

How to create a testing table in oracle?

1036

How to set a transaction to be read only in oracle?

1139

What is PL/SQL ?

2220

Why do you create or replace procedures rather that drop and recreate.

1070

Can we create database in oracle using command line ?

1134

What is not equal to in oracle?

1049

how can we store any pdf file in oracle

2221