Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the
rows available?
A.
SELECT * FROM tab1 FIND FIRST 50 ROWS
B.
SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY
C.
SELECT * FROM tab1 WHILE ROW_NUM < 50
D.
SELECT * FROM tab1 MAXROWS 50
B.
SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY
fetch-first-clause
FETCH FIRST N ROWS ONLY
0
0