SELECT * FROM EMP WHERE ROWNUM<=4;

How to display First 4 rows From Database Table?

Question Posted / b v n kiran kumar

Answer Posted / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the differences between char and nchar in oracle?

1096

How does oracle handle read consistency?

1097

How to set up autotrace for a user account?

1059

What is the simplest tool to run commands on oracle servers?

1009

What are nested tables?

1174

What are the ways tablespaces can be managed and how do they differ?

2367

How to import one table back from a dump file?

1025

Explain the blob datatype?

1071

What is an oracle recycle bin?

1009

What are the attributes that are found in a cursor?

1076

Explain a synonym?

1029

defination of bitmap index

2125

How to create a temporary table in oracle?

1268

How to get execution path reports on query statements?

987

Is a rollback possible to any savepoint?

1095