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 do we get field details of a table?

978

How to call a stored function with parameters?

1046

What is the difference between formal parameters and actual parameters?

1089

what are the default admin accounts in Oracle 10g ?

969

Â What are the oracle DML commands possible through an update strategy?

1064

what is insert all statement in sql

6520

What is translate in oracle?

1100

State the various uses of dbcc command?

1060

Give the different types of rollback segments.

1031

what is a Nested Loop join?

2117

Respected sir, Please send me technical questions related to oracle apps..

1813

How to use existing values in update statements using oracle?

1067

How to start a specific oracle instance?

1038

Is primary key indexed by default in oracle?

987

How to join two tables in a single query using oracle?

997