How can u Fetch first row Only ?
Posted: Mon Dec 13, 2010 12:18 pmHow can u Fetch first row Only ?
IBM Mainframe Forum
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
How can u Fetch first row Only ?
Page 1 of 1
Posted: Mon Dec 13, 2010 12:18 pmRe: How can u Fetch first row Only ?
Posted: Mon Dec 13, 2010 2:14 pmby coding fetch first rows only
Re: How can u Fetch first row Only ?
Posted: Thu Dec 23, 2010 2:06 pmUse FOR FETCH ONLY
Re: How can u Fetch first row Only ?
Posted: Thu Dec 23, 2010 2:23 pmSelvaraj wrote:Use FOR FETCH ONLY
Nope, that's not it.
Re: How can u Fetch first row Only ?
Posted: Fri Dec 24, 2010 1:27 amHello,
You should only post suggestions that you have actually tested. . .Use FOR FETCH ONLY
Re: How can u Fetch first row Only ?
Posted: Wed Dec 29, 2010 3:54 pmFirst 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
First 10 rows Fetch from employee table: Query is --> SELECT * FROM EMPLOYEE FETCH FIRST 10 ROWS ONLY