The people who run our mysql server are using version 3.23.51, so I don't
have access to some of version 4's features like sub selectes.
I have a table with data like this:
firm firm_rank time time_rank student
A 1 10 1 jones
A 1 10 1 smith
A 1 10 1 alvin
A 2 10 1 bob
A 2 10 2 charlie
This might help.
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
I had the same problem. Before I found the webpage above, I went with a less
efficient but simpler way. I wanted the highest revision (revision) for each news
article (id).
$SQL = CREATE TEMPORARY TABLE