Thanks, Charles/ Rohan Corea 818-451-6705 www.linkedin.com/in/rohancorea
On Wed, Nov 8, 2023 at 1:36 PM Charles Stevens <stevens...@gmail.com> wrote: > 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 > <https://groups.google.com/d/msgid/rbase-l/CADAyCN_%3DJ-L4uQFOFdZikojR_GoiJiL%3DBPWAy7Hi3FaJAO16vw%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/CAAHAmbtJ6BD%2BzjUbhOSpqSm3d87jHXAGnUDdoZaU3oS%3DwWjiWA%40mail.gmail.com.