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
How would the varchar column remarks defined?
When the like statement is used?
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.
What is copy pending status in db2?
What is the maximum size of a char data type in db2?
How to execute stored procedures?
What is check constraint in db2?
What is the use of runstats in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Outputs of explain are with matchcols = 0. What does this signify?
What is the usage of open cursor command?
can we view the access paths created by dbrm ? how ? thx
What is the connection string to connect to the DB2 Database ?
what is a corelated subquerry?
Can there be more than one cursor open for any program?