IBM Mainframe Forum

How can u Fetch first row Only ?

by coding fetch first rows only

Use FOR FETCH ONLY

Selvaraj wrote:Use FOR FETCH ONLY

Nope, that's not it.

Hello,

Use FOR FETCH ONLY

You should only post suggestions that you have actually tested. . .

First row Fetch from employee table : Query is --> SELECT * FROM EMPLOYEE FETCH FIRST ROW ONLY
First 10 rows Fetch from employee table: Query is --> SELECT * FROM EMPLOYEE FETCH FIRST 10 ROWS ONLY