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 ?

16 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is SQL access advisor in Oracle?

1182

What are the attributes of cursor?

1044

What is the difference between pre-select and pre-query?

1207

What are the restrictions in a oracle read only transaction?

1024

What is java oracle used for?

1014

How to drop a stored procedure in oracle?

1045

Does oracle charge for java?

1051

How to end the current transaction in oracle?

1020

Can we call procedure inside function in oracle?

1071

What do you mean by redo log file mirroring?

1018

Explain the use of log option in exp command.

1107

Explain user account with reference to oracle.

969

What is SQL Tuning Advisor in Oracle?

1163

What is index in Oracle?

1063

Will you be able to store pictures in the database?explain.

986