Hi. This is the documented behaviour. For details, see http://www.mysql.com/doc/G/r/Group_by_functions.html
How to deal with this is discussed in the tutorial section: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Bye, Benjamin. On Sat, Mar 30, 2002 at 09:24:26PM +0800, [EMAIL PROTECTED] wrote: > Everyone, > > Is this a bug or something....i am using the latest version of MySQL server > and it works fine and convincing...but I observe that if I use the MAX() > function....i got this > > I include max() function to my select query.... > > Ex.. > > select max(A),B,C from table_name group by A; > > the result is not convincing....coz column B and C are not partner of > A....if I manually select A,B,C from table_name; the result is not same with > the other.... > > Assuming A is integer and B,C are string partners.... > > Anybody got this situation before...I badly need your opinion about > this....i solve the problem by using a re-query method and its > programmatically done...so I need a more precise and exact way to get > this... or any explanation why the server response my query this way? > > R.B.Roa [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
