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 to do if dba lost the system password?

1087

How to experiment a data lock in oracle?

999

What is memory advisor in Oracle?

1022

How do I know if oracle is installed on windows?

878

What is a tns file?

938

What is the difference between Delete, Truncate and Drop in Oracle?

1065

what is the scenario where you take the database to NoArchivelog mode?

2257

Explain constraining triggers.

1043

How to run queries on external tables?

988

How to create a table interactively?

996

What is the relation of a user account and a schema in oracle?

1006

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

How would you begin to troubleshoot an ORA-3113 error?

2023

What is define in oracle?

998

How to view the data files in the current database?

1042