select 100 records from million records ?

Question Posted / visu.kanchamreddy

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

Answers were Sorted based on User's Feedback

select 100 records from million records ?..

Answer / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Is This Answer Correct ?

20 Yes

0 No

select 100 records from million records ?..

Answer / 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

More DB2 Interview Questions

how to resolve -811

2 Answers IBM,

How many buffer pools are there in DB2?

2 Answers

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers

What is runstats and reorg in db2?

0 Answers

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers IBM,

How to check table size in db2 sap?

0 Answers

How can you get the number of rows impacted by the last executed query?

1 Answers

What is db2 purescale?

0 Answers

Can one database have multiple instances?

0 Answers

how can u nderstand the sql stmts executed successfully or not ?

1 Answers TCS,

What is the difference between primary key & unique index ?

6 Answers Patni, Temenos,

For more DB2 Interview Questions Click Here