Hi, I am running MySQL 4.0.10 gamma. I have records with data: id title version 1 a 1 2 a 2 3 b 1 4 b 2
How do I select all the records with highest version for each title? (The records with id 2 and 4) I've been thinking about combinating GROUP BY and max(), but I cant get it to work... "SELECT id, title, max(version) FROM table GROUP BY title;" returns 1 a 2 3 b 2 Thanks for any help /Ola
