SELECT * FROM TABLENAME FETCH FIRST 100 ROWS ONLY; This will fetch 1st

select 100 records from million records ?

Question Posted / prachi

2 Answers
7950 Views
Verizon, I also Faced
E-Mail Answers

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

What is cascading rollback?

1191

Explain db2.

1016

Explain about rct in db2?

1091

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.

3188

What is difference between alias and synonym in db2?

1119

What is the use of runstats in db2?

1089

What is db2 stogroup?

1145

What is phantom read in db2?

1136

Explain the function done by data manager?

1261

What is reorg?

1133

What is meant by explain?

1113

What is the difference between nvl and coalesce?

1052

What is buffer pool in the db2 database?

1081

Can you tell me how can you find out the # of rows updated after an update statement?

1081

Define predicate?

1104