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 <rkco...@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 > 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 rkco...@gmail.com >> To rbase-l@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 >> 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+unsubscr...@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+unsubscr...@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+unsubscr...@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/CADAyCN9svFzX39OWBLYDeqio%3Ddpd7LqV2tBDf9jLe%2BitA44X%2BQ%40mail.gmail.com.
