if u want to fetch first 100 go for select * from tablename fetch only 1

select 100 records from million records ?

Question Posted / ankit.:-)

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

Answer Posted / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

Is This Answer Correct ?

5 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why db2 is called db2?

1051

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.

3218

Give the name of some fields form sqlca.

1091

On which levels locks can be applied?

1143

What is the role of the data page in the db2 database?

1028

What is a buffer in memory?

1065

What is dbrm?

1112

What is null indicator in db2?

1120

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1063

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1053

What is concurrency?

1240

What is db2 command?

1043

Mention the different locking levels that are available in db2.

1138

Comment whether the cursor is closed during commit or not.

1112

Why do we bind in db2?

1216