Without using a subquery, you have to do it in two steps. First you need
to collect the MAX(col2) values for each col1 value:
CREATE TEMPORARY TABLE tmpMaxes
SELECT col1, max(col2)
from test_table
GROUP BY col1
Then you want to get the rows where the col2 value is the maximum for each
col1 val
Hi,
I'm using MySQL 4.0.18 on Win2k Server. I have a table similar to the
following:
col1col2col3
A 1 this
A 2 is
A 3 a
B 1 test
B 2 table
What I would like to get with one query is the following result:
col1
