Selon Mathias <[EMAIL PROTECTED]>: > 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] > >
errata : Hi Matt, SELECT DISTINCT(distance) FROM fiber_config WHERE fiber_type = 2 AND bandwidth > least(2200, 2200, 2200, 220) ORDER BY distance ASC least not min coz it's a row data, not column one. 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]