HAVING worked OK thus ..... - > What would this mean? The WHERE clause is what determines what rows > will be used in the GROUP BY functions, e.g. MIN(). How do you know > what rows to use when you need to know what rows to use before you > can figure out the criteria for what rows to use? > Trying to express in words what you wish to accomplish, I'd say that > you want the smallest of all my_column such that this value is greater > than ten. This would be equivalent to WHERE my_column > 10, but if > that's what you want I suppose you wouldn't be asking. > > Someone suggested HAVING, but as far as I can see using HAVING to > accomplish MIN(column)>constant is equivalent to WHERE column>constant. > > //C - not wearing his glasses > > -- > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ > Amiga user since '89, and damned proud of it too. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
