DB2-Limit SQL Query

This is and example on how to limit a no of lines to display during DB2 SQL Query.

SELECT * FROM TEST.CUSTOMER WHERE LASTNAME='SMITH' FETCH FIRST 10 ROWS ONLY;