[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: SELECT TOP (100, 100)
From:       "Pavel Konovalov" <pasha () rscom ! ru>
Date:       2002-10-31 6:33:07
[Download RAW message or body]

----- Original Message -----
From: "Fox" <plc2000@wp.pl>
To: <sapdb.general@listserv.sap.com>
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
sapdb.general@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
[prev in list] [next in list] [prev in thread] [next in thread]