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
