Hi, I'm using MySQL 4.0.18 on Win2k Server. I have a table similar to the following:
col1 col2 col3 ---------------- 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 max(col2) col3 ---------------------- A 3 a B 2 table I've searched around, but haven't been able to come up with anything. This query doesn't give me the correct results: select col1, max(col2), col3 from table group by col1 Any suggestions? Thanks in advance, Matt
