how to fetch first 100 rows in db2

Question Posted / guest

2 Answers
12986 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to fetch first 100 rows in db2..

Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Is This Answer Correct ?

34 Yes

2 No

how to fetch first 100 rows in db2..

Answer / jagan

select top 100 from tableName;

Is This Answer Correct ?

1 Yes

12 No

Post New Answer

More DB2 Interview Questions

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers Hewitt,

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers

What type of database is db2?

0 Answers

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers

can you use symbolic parameters in JOB?

5 Answers IBM,

What is dbrm? What it contains?

0 Answers

what is check point and restart Logic ? why do we go for that ??

2 Answers CGI, UST, Xansa,

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers Wipro,

Which isolation level provides highest data integrity?

0 Answers

What is dynamic SQL?

1 Answers ADP,

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers

For more DB2 Interview Questions Click Here