select 100 records from million records ?

Answer Posted / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Is This Answer Correct ?    20 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would the varchar column remarks defined?

603


When the like statement is used?

607


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2733


What is copy pending status in db2?

607


What is the maximum size of a char data type in db2?

570






How to execute stored procedures?

604


What is check constraint in db2?

581


What is the use of runstats in db2?

552


Which command is used to connect to a database in DB2 ? Give the Syntax.

578


Outputs of explain are with matchcols = 0. What does this signify?

597


What is the usage of open cursor command?

586


can we view the access paths created by dbrm ? how ? thx

6195


What is the connection string to connect to the DB2 Database ?

594


what is a corelated subquerry?

630


Can there be more than one cursor open for any program?

635