I've got a table which is used for storing votes, each row has a field with
a reference to the user who's been voted for and i'd like to simply get the
user ref with the most votes,or if tied, return both of them. I cant use
subqueries as it's a mysql 4.0 server, any ideas on how i could do it
(without retrieving all the nominees then doing select count(*) for all of
them then sorting them externaly).
thanks,
peter