Is also coincidence that ID1 is less than ID2 in the selected rows?
Could that be a SEL criteria?
Doug
On 11/27/2018 8:48 AM, [email protected] wrote:
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] <[email protected]> *On Behalf
Of *Dan Goldberg
*Sent:* November 27, 2018 9:37 AM
*To:* [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
---
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.
--
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]
<mailto:[email protected]>.
For more options, visit 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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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.
