Hello Philip, that was my first choice, too. But no, error 1111: Invalid use of group function
and select col1, max(col2) from table; is error 1140: mixing of group cols with non group� cols is illegal (That would other sql backends say too) and other variants of the above like "select col1 from table t1, table t2 where ....=max(col2)" result in the same error reports Perhaps someone else has an idea? Best regards Sabine Philip Spradling wrote: > > I could be missing something, but what about: > > select col1 from t1 where col2 = max(col2); > > On Sun, 12 May 2002 23:04:14 +0200 > Sabine Richter <[EMAIL PROTECTED]> wrote: > > > Hello, > > > > I just want to get the value of one column in the row where max of > > another col of this table is. > > With the possibility of sub queries I would write: > > > > select col1 > > from table t1 > > where col2 = (select max(col2) > > from tab1e t2); > > > > > > But how to do it without a sub query? > > Just with 1 statement? > > I find no solution. > > > > Not wanting to believe there is none > > Sabine > > > > --------------------------------------------------------------------- > > 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 --------------------------------------------------------------------- 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
