select * from employees where rownum<=4

How to display First 4 rows From Database Table?

Question Posted / rathi.sql

Answer Posted / rathi.sql

select * from employees
where rownum<=4

Is This Answer Correct ?

24 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the original export and import utilities?

1058

How to install oracle odbc drivers?

1040

Is there a function to split a string in plsql?

983

How to connect asp pages to oracle servers?

1007

What is the quickest way to export a table to a flat file?

920

Explain the use of compress option in exp command.

969

What are the different types of modules in oracle forms?

952

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

918

What is a dead lock in oracle?

1050

How to add a new column to an existing table in oracle?

1072

Explain a private synonyms?

983

What is oracle rownum?

889

What is the usage of save points in oracle database?

909

How many memory layers are in the oracle shared pool?

1107

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670