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
