Selon [EMAIL PROTECTED]: > "Matt Babineau" <[EMAIL PROTECTED]> wrote on 07/01/2005 05:05:28 PM: > > > Hi Again - > > > > I need some more help with a query. I have a list of numbers (bandwidth > > required)... 2200, 2200, 2200, 400, 320 > > > > My data looks like this: > > > > Bandwidth | Distance > > -------------------- > > 2250 | 10km > > 1125 | 10km > > 622 | 10km > > 2250 | 20km > > 1125 | 20km > > 622 | 20km > > 2250 | 40km > > 1125 | 40km > > 622 | 40km > > > > I need the query to look at the list of numbers, and figure out that a > > certain distance has Bandwidths that are greater than each of the > numbers. > > > > SELECT DISTINCT(distance) FROM fiber_config WHERE fiber_type = 2 AND > > bandwidth > (2200, 2200, 2200, 220) ORDER BY distance ASC > > > > So I hope you can see what I am trying to get after. Basically I need to > > fins a distance that can fit each of the numbers in the list. So if 2200 > is > > in the list, 2250 works. If 400 is in the list, 622 works. Thanks for > the > > help on this! > > > > > > > > Thanks, > > > > Matt Babineau > > Criticalcode > > 858.733.0160 > > [EMAIL PROTECTED] > > http://www.criticalcode.com > > > Actually, no. I can't see what you are trying to get after. I don't have > enough context to work from. > > I just cannot visualize your problem well enough to help. What is the > tuple/list of numbers (2200,2200,2200,220) supposed to represent and how > would you use this list to find the records you wanted if you were doing > it "by hand"? > > Imagine for me that none of this information is in a computer but has been > printed out on paper. Now describe for me the decision process you want to > perform and how I would do it using the printed lists. What would I need > to compare to come up with the correct choices? > > Make sure you respond to the list so that everyone else can help, too! > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > Hi Matt, SELECT DISTINCT(distance) FROM fiber_config WHERE fiber_type = 2 AND bandwidth > min(2200, 2200, 2200, 220) ORDER BY distance ASC
Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
