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 recovery manager(rman) backup in Oracle?

1127

How to drop an existing table in oracle?

1015

What are the differences between lov and list item?

992

Is there any function in oracle similar like group_concat of mysql?

989

Is oracle a language?

900

Explain implicit cursor.

963

How to pass parameters to procedures?

975

How to create a table interactively?

998

definition of cluster and non-clustered index?

2961

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1870

What do you mean by merge in oracle?

939

How to define an external table with a text file?

1021

Explain oracle 12c new features for developers?

995

How many categories of data types?

940

How to fetch the row which has the max value for a column?

950