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 a synonym?

971

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2045

What is analyze command used for?

1012

What is the difference between I and G in Oracle?

1023

What is the meaning of recursive hints in oracle?

995

How to download oracle database 10g xe?

960

How to rename an index?

997

What are the various oracle database objects?

1093

How to empty your oracle recycle bin?

981

Is rowid unique in oracle?

939

Explain database link?

1062

What is an oracle and why it is used?

1080

How to store only time; not date and time?

960

What are the parameters that we can pass through a stored procedure?

1000

How do I find my oracle client driver version?

972