home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,174 of 2,288   
   .com to dbarchitech   
   Re: sql to find a numeric range inside a   
   02 Mar 04 18:08:38   
   
   From: mcstockX@Xenquery   
      
   "dbarchitech"  wrote in message   
   news:9d3dc423.0403021434.18a3078e@posting.google.com...   
   | hi,   
   |   
   | i'm building a query to find narrow ranges of zip codes within broader   
   | ranges in a table (for tax purposes). for example:   
   |   
   | LOW_ZIP    HI_ZIP   
   | 23400       23499   
   |   
   | need to find   
   | 23401      23402   
   | 23403      23440   
   | 23441      23... you get the picture. :)   
   |   
   | so, each row has a low value and a hi value, then i need to run a   
   | subquery to take those values and find narrower ranges. any ideas?   
      
   yeah, but you got to show us yours first ;-)   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca