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

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1867

Explain compound trigger in oracle?

996

How to synchronize 2 schema's objects?

2130

Explain about achiever in sql?

988

What is literal?

967

What are the data types in oracle?

995

What do you understand by a database object?

1002

Explain rename?

939

Explain oracle’s server parameter file.

962

What are the different oracle database objects?

1042

What is the usage of save points in oracle database?

927

How to export your own schema?

984

What is a oracle database?

1011

How can we force the database to use the user specified rollback segment?

1091

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

961