How to display First 4 rows From Database Table?

Answer Posted / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to end the current transaction in oracle?

561


What happens to the current transaction if a ddl statement is executed?

580


How to synchronize 2 schema's objects?

1690


What is a initialization parameter file in oracle?

584


Why is oracle so popular?

561






What is an external table?

588


Difference between hot backup vs. Cold backup?

606


Why is oracle used?

557


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

558


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558


How to get a list of all user accounts in the database?

618


How can you use check constraints for self referential integrity?

526


How to execute a stored program unit?

583


what's query optimization and without use of IN AND Exist can we get another way data from query

1670


Explain the difference between a procedure and a function? What do you understand by those terms?

624