----- Original Message -----
From: "Fox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 7:51 PM
Subject: SELECT TOP (100, 100)


> How to type query witch returns to me x records starting from y.
>

select <fields> from (select rowno nn, <fields> from <table>) where nn >= Y
and nn < Y+X


Pavel Konovalov
________________________________
JS RCOM, Russia
http://www.rscom.ru


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to