how to fetch first 100 rows in db2

Question Posted / guest

2 Answers
13274 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

What is the error code -803 ?

3 Answers

what is a corelated subquerry?

0 Answers IBM,

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers

Which component is responsible for db2 startup and shutdown?

0 Answers

How to handle null values in db2

4 Answers

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers Amdocs, HeadStrong,

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers IBM,

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers

What is meant by union and union all?

0 Answers

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers

Is the primary key a clustered index?

0 Answers

What is a SELECT statement?

1 Answers

For more DB2 Interview Questions Click Here