How to display First 4 rows From Database Table?

Answer Posted / testing

you can get the first four rows using this query

select * from emp limit 4

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to recover a dropped table in oracle?

609


Can you drop an index associated with a unique or primary key constraint?

587


Difference between varchar and varchar2 data types?

668


What is a dead lock in oracle?

598


List the parts of a database trigger.

584






What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021


How to connect the oracle server as sysdba?

633


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1276


What is oracle and what are its different editions?

581


How to define a variable to match a table column data type?

580


how to do daily transactions with out sql* loader control file regesterd in apps?

1224


What would you do with an in-doubt distributed transaction?

1472


How to select some rows from a table in oracle?

598


what is insert all statement in sql

5520


Explain parameter file in oracle.

580