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

Explain what are the advantages of views?

804

Difference between oracle's plus (+) notation and ansi join notation?

830

How to select an oracle system id (sid)?

781

Difference between open_form and call_form in oracle.

871

Name the three major set of files on disk that compose a database in Oracle?

827

Can group functions be used in the order by clause in oracle?

764

How to delete all rows a table in oracle?

804

What are oracle functions?

765

What is a oracle database?

804

What is ASM (Automatic Storage Management) in Oracle?

888

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

769

What are the limitations of check constraint?

767

Explain the use of indexes option in imp command.

770

How to create a new table by selecting rows from another table?

823

query optmization techniques and quwry analyser+projects+ppts

2142