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 oracle instant client?

1001

What is a named program unit?

1048

What is a trigger oracle?

1071

How to initialize variables with default values?

1209

How view is different from a table?

1015

What is procedure overloading in oracle?

1029

What are a cluster and non-cluster index?

993

What is the minimum client footprint required to connect c# to an oracle database?

1071

how to clone 9i Database on to 10g Database.

2319

What are the execution control statements in oracle?

1064

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2112

How to connect to a local oracle 10g xe server?

970

What is concurrency in oracle?

983

How do we display rows from the table without duplicates?

953

What are the limitations of check constraint?

1006