...have you tried SELECT (MIN(distance))? -----Original Message----- From: Dan Goldberg <[email protected]> To: "[email protected]" <[email protected]> Date: Wed, 19 Jul 2017 21:52:27 +0000 Subject: RE: [RBASE-L] - get the minimum and store it
Thx. I need to get the minimum distance and dlrnum by loczipcode. That is the tricky part. Data example. Dlrnum distance loczipcode Abc 5 93535 Def 2 93535 Dan From: [email protected] [mailto:[email protected]] On Behalf Ofjan johansen Sent: Wednesday, July 19, 2017 2:50 PM To: [email protected] Subject: Re: [RBASE-L] - get the minimum and store it INSERT INTO + mytable + SELECT distance, dlrnum, loczipcode, dlrzipcode + FROM myview -----Original Message----- From: Dan Goldberg <[email protected] [mailto:[email protected]]> To: "[email protected] [mailto:[email protected]]"; <[email protected] [mailto:[email protected]]> Date: Wed, 19 Jul 2017 21:38:16 +0000 Subject: [RBASE-L] - get the minimum and store it I am drawing a blank. I have a view that has distance, dlrnum, loczipcode, dlrzipcode I want to extract the dlrnum, loczipcode, dlrzipcode from the view based on the minimum distance and store it in a table. What would be the code to store it in a table? TIA Dan Goldberg -- 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]. -- 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]. -- 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]. -- 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.
