Replacing Limit x,y with JDBC
[email protected] Wed, 7 May 2003 19:15:43 -0400
| Newsgroups | gmane.comp.db.sapdb.sources |
|---|---|
| Message-ID | <[email protected]> |
Hi,
Am migrating our db from mySQL which has Limit X,Y function, to SAP.
I saw on the list a suggestiong to use
SELECT * from tbl WHERE ROWNO <= 20
FETCH POS (10) INTO ... (if you want to see result number 10,
otherwise use 11)
Loop
FETCH NEXT INTO ...
Endloop
But don't see how that will work with a single JDBC call.
Does anyone know how to mimic this with a single call?
Many thanks,
David