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
