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. > > > *AKA Bare Chested Chuck* > > On Mon, Nov 6, 2023 at 5:28 PM <[email protected]> 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 <[email protected]> >> wrote: >> >>> Rohan, try: >>> >>> SELECT ALL FROM customer *WHERE* LIMIT = 5 >>> >>> Bruce >>> >>> >>> ------ Original Message ------ >>> From [email protected] >>> To [email protected] >>> 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 [email protected]. >>> 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 [email protected]. >>> 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 [email protected]. >> > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f7236c1d-fade-4987-8133-2c01e4fbbd0cn%40googlegroups.com.
