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

Explain oracle insert into command?

1158

Why oracle is used?

1108

How do I connect to oracle?

1080

What is the difference between hot backup and cold backup in oracle?

1078

How to use attributes of the implicit cursor in oracle?

1064

What is oracle analytical function?

1234

What is background process in Oracle?

1140

What is transport network substrate (tns) in oracle?

1096

please explain.. DB architecture ...

2082

How to set up autotrace for a user account?

1113

What is an oracle recycle bin?

1065

What is a partition in oracle?

1207

How to pass parameters to procedures?

1089

What is meant by raw datatype?

1119

What are the different types of synonyms?

1200