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 differences between primary key and unique key?

507

Is oracle an open source?

632

what is a Nested Loop join?

1563

Explain oracle’s server parameter file.

564

How to assign a tablespace to a users in oracle?

587

Explain a private synonyms?

630

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1874

What are the most common interview questions on ETL Testing for experience?

589

Explain joins in oracle?

559

How to delete multiple rows from a table in oracle?

560

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

856

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1464

How to define a specific record type?

616

How to do a full database export?

631

Is java required for oracle client?

546