MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Select row with highest "pass" number, where user ID is the same in each row
Posted by: Peter Brawley
Date: August 26, 2014 12:10PM

> (with array like behaviour

In MySQL, "array" is spelled "table".

No need for a temp table, eg you could maintain a fixed intermediate table, use a unique batch ID for each new computation, and delete the data with that ID when the computation's done. Or do it the pre-MySQL-5 way--save the aggregating query result to another temp table, then join that with your results table.

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.