SELECT * FROM EMP WHERE ROWNUM<=4;

How to display First 4 rows From Database Table?

Question Posted / b v n kiran kumar

6 Answers
9659 Views
I also Faced
E-Mail Answers

Answer Posted / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to check your oracle database 10g xe installation?

981

What does sharding mean?

990

How to write date and time literals in oracle?

994

How can we create the complete backup of data in the oracle.

2148

What is transaction control statement and how many types of transaction control statement in Oracle?

1147

What happens if the imported table already exists?

1026

How to run create database statement again?

1143

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2057

What is an oracle and why it is used?

1138

What is catalog in Oracle?

1349

What is an oracle database?

1031

is there a tool to trace queries, like profiler for sql server?

1137

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

1806

What are transaction isolation levels supported by oracle?

1057

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1128