Page 1 of 1
How can u Fetch first row Only ?
Posted:
Mon Dec 13, 2010 12:18 pm
by ragur.satheesh
How can u Fetch first row Only ?
Re: How can u Fetch first row Only ?
Posted:
Mon Dec 13, 2010 2:14 pm
by GuyC
by coding fetch first rows only
Re: How can u Fetch first row Only ?
Posted:
Thu Dec 23, 2010 2:06 pm
by Selvaraj
Use FOR FETCH ONLY
Re: How can u Fetch first row Only ?
Posted:
Thu Dec 23, 2010 2:23 pm
by GuyC
Selvaraj 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 am
by dick scherrer
Hello,
Use FOR FETCH ONLY
You should only post suggestions that you have actually tested. . .
Re: How can u Fetch first row Only ?
Posted:
Wed Dec 29, 2010 3:54 pm
by chandrababun
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