Bill, my example above used the RowID as the “ordering" column, and returned the results from his admittedly small sample set. That is how I read his query.
Albert > On Nov 27, 2018, at 11:04 AM, Bill Downall <[email protected]> wrote: > > Unfortunately for you, Paul, the SQL definition of a table is "an unordered > set of rows." So the concept of a "next row" is problematic to building a > query. Your query provides the order through the ORDER BY clause. > > Will the ID2 column match a ID1 column more than once in the table? > > I'd be working on something like: > > SELECT t1.ROWID, t1.PART_ID, t1.ID1, t1.ID2 + > FROM tablename t1 + > WHERE t1.ID2 NOT IN + > (SELECT t2.ID2 FROM tablename t2) + > ORDER BY 1,2,3,4 > > Bill > > On Tue, Nov 27, 2018 at 10:27 AM <[email protected] > <mailto:[email protected]>> wrote: > Dan, > > > > It will always be the previous row. I would sort on the ID1 column so it > would always be the previous row. > > > > Thanks, > > Paul > > > > From: [email protected] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> On Behalf Of Dan > Goldberg > Sent: November 27, 2018 10:09 AM > To: [email protected] <mailto:[email protected]> > Subject: RE: [RBASE-L] - SQL Help - OT > > > > Is it only from the previous row or any of the rows? > > > > Dan Goldberg > > > > > > From: [email protected] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> On Behalf Of > [email protected] <mailto:[email protected]> > Sent: Tuesday, November 27, 2018 6:48 AM > To: [email protected] <mailto:[email protected]> > Subject: RE: [RBASE-L] - SQL Help - OT > > > > Dan, > > > > Thanks but it’s only coincidental that the sample I created I needed the > “odd” rowid’s. My guess is it will be 50/50 odd or even. > > > > What I need is to check ID1 & ID2 and if the ID1 from the next row equals the > ID2 from the previous row I don’t select that row. > > > > Thanks anyway, > > Paul > > > > From: [email protected] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> On Behalf Of Dan > Goldberg > Sent: November 27, 2018 9:37 AM > To: [email protected] <mailto:[email protected]> > Subject: RE: [RBASE-L] - SQL Help - OT > > > > You can do this to get the odd rowid values in rbase. > > > > Select ROWID, PART_ID, ID1, ID2 from tablename where (MOD(ROWID,2)) = 1 > > > > Dan Goldberg > > > > > > > > From: [email protected] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> On Behalf Of > [email protected] <mailto:[email protected]> > Sent: Tuesday, November 27, 2018 6:23 AM > To: [email protected] <mailto:[email protected]> > Subject: [RBASE-L] - SQL Help - OT > > > > Good morning, > > > > I need some help with a SQL select command, not specifically for R:BASE. See > my little table sample below. What I’d like to end up with after the SQL > select is the following rows: > > > > Results of SQL Select/Query > > ROWID PART_ID ID1 > ID2 > > 1 PV216365006R -00105 > -00106 > > 3 PV216365006R -00107 > -00108 > > 5 PV216365006R -00109 > -00110 > > 7 PV216365006R -00111 > -00112 > > > > Sample Table to Query > > ROWID PART_ID ID1 > ID2 > > 1 PV216365006R -00105 > -00106 > > 2 PV216365006R -00106 > -00105 > > 3 PV216365006R -00107 > -00108 > > 4 PV216365006R -00108 > -00107 > > 5 PV216365006R -00109 > -00110 > > 6 PV216365006R -00110 > -00109 > > 7 PV216365006R -00111 > -00112 > > 8 PV216365006R -00112 > -00111 > > > > I know how I’d do this in a Declare statement in R:BASE but as I said, it has > to be done with a SQL select command. > > > > Any blues clues would be greatly appreciated. > > > > TIA, > > Paul Buckley > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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]. For more options, visit https://groups.google.com/d/optout.
