IBM Exam Questions

which of the following statement will only return the first 25 of the rows?

If table TABLE1 contains 250 rows, which of the following statement will only return the first 25 of
the rows?

A.
SELECT * FROM table1 MAXROWS 25

B.
SELECT * FROM table1 RETURN FIRST 25 ROWS

C.
SELECT * FROM table1 WHILE ROW < 25

D.
SELECT * FROM table1 FETCH FIRST 25 ROWS ONLY

Explanation: