The documentation I have shows LIMIT without an "=" sign with two parameters, i.e.: LIMIT X, Y where X is the first row (starting at 0) and Y is the number of rows to retrieve. It does work as per the documentation. The alternative, with an "=" sign, returns the specified number of rows always starting from the first row as "0". It seems the former LIMIT command has more versatility. I, too, am familiar with the latter command and just learned of the former. The question is definitely legit.
*AKA Barechested Chuck* On Tue, Nov 7, 2023 at 9:40 AM baue...@gmail.com <bauer...@gmail.com> wrote: > His question is legit though. I have always used the equal sign, but the > doc example shows: > > LIMIT > With one argument, the value specifies the number of rows to return from > the beginning of the result set, which retrieves the first 5 rows: SELECT > * FROM table LIMIT 5 > > and it does not work as shown, but adding the equal sign makes it so. I > would ask RBTI to take a look to see if the docs are wrong or the parser > has been changed in some way. > > > > On Monday, November 6, 2023 at 10:05:14 PM UTC-5 Charles Stevens wrote: > >> Hey, Rohan - >> >> The documentation you cite works with two parameters. Offset is the first >> row, and row_count is the number of rows. If you want to see, for example, >> rows 100 to 120, enter 'LIMIT 100, 20'. What Bruce cites also works, >> starting at row 0 and taking the next 20 rows. >> > > >> On Mon, Nov 6, 2023 at 5:28 PM <rkc...@gmail.com> wrote: >> >>> That works, Bruce. Thanks. >>> >>> here is the documentation and it does not need a where clause. >>> [image: image.png] >>> Thanks for your assistance, Bruce. >>> Rohan Corea >>> 818-451-6705 <(818)%20451-6705> >>> www.linkedin.com/in/rohancorea >>> >>> >>> On Mon, Nov 6, 2023 at 2:18 PM Bruce Chitiea <rby...@safesectors.com> >>> wrote: >>> >>>> Rohan, try: >>>> >>>> SELECT ALL FROM customer *WHERE* LIMIT = 5 >>>> >>>> Bruce >>>> >>>> >>>> ------ Original Message ------ >>>> From rkc...@gmail.com >>>> To rba...@googlegroups.com >>>> Date 11/6/2023 2:12:25 PM >>>> Subject [RBASE-L] - Limit command does not work as documented >>>> >>>> I am using the Concomp database as an example. The following statement >>>> does network >>>> select all from customer limit 5 >>>> However, if I use orderby clause before limit, it works >>>> browse all from customer order by CustID limit 10 >>>> Is it a bug? >>>> >>>> Rohan Corea >>>> 818-451-6705 <(818)%20451-6705> >>>> www.linkedin.com/in/rohancorea >>>> >>>> -- >>>> For group guidelines, visit >>>> http://www.rbase.com/support/usersgroup_guidelines.php >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "RBASE-L" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to rbase-l+u...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/rbase-l/CAAHAmbtsuSaEPJY47c4ATmLmVzCKaeLhe%2B6iqNOmop__BXzsBg%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/rbase-l/CAAHAmbtsuSaEPJY47c4ATmLmVzCKaeLhe%2B6iqNOmop__BXzsBg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> -- >>>> For group guidelines, visit >>>> http://www.rbase.com/support/usersgroup_guidelines.php >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "RBASE-L" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to rbase-l+u...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/rbase-l/eme4fcba36-4883-4089-ac0d-019109d167fe%40ffc94789.com >>>> <https://groups.google.com/d/msgid/rbase-l/eme4fcba36-4883-4089-ac0d-019109d167fe%40ffc94789.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to rbase-l+u...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/rbase-l/CAAHAmbto%2B3KUOa4O_%2B4pa5powHxvnFX7RUhoBHkK-1c%3DaRvBgA%40mail.gmail.com >>> <https://groups.google.com/d/msgid/rbase-l/CAAHAmbto%2B3KUOa4O_%2B4pa5powHxvnFX7RUhoBHkK-1c%3DaRvBgA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> >> -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/f7236c1d-fade-4987-8133-2c01e4fbbd0cn%40googlegroups.com > <https://groups.google.com/d/msgid/rbase-l/f7236c1d-fade-4987-8133-2c01e4fbbd0cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CADAyCN_%3DJ-L4uQFOFdZikojR_GoiJiL%3DBPWAy7Hi3FaJAO16vw%40mail.gmail.com.
