Pavel Konovalov wrote > Possible in SAP DB to superimpose the restrictions not only > on amount taken > out in > select ( select.... where rowno < 10) but also on that with what (on > order ) record to > begin the conclusion ( Next 10 records, as operator SELECT... LIMIT in > MySQL).
There is no construct in SAP DB like the offset within the MySQL limit operator but perhaps this recycled mail from Elke may help you: Perhaps you client environment will allow you something like this : select idfrom dvd order by id ASC FETCH POS (5) INTO ... mycounter = 5; Loop mycounter = mycounter + 1; FETCH NEXT INTO ... Endloop when mycounter == 10 or some error occurs FETCH POS (n) jumps to the n-th result and returns it. n can be specified with integer or parameter. Not every client tool will be able to use FETCH POS. But is is a good chance for you. FETCH NEXT will give the next result from that point. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
