displaying a specific row within a group by

Consider the ff. table: ++--+--+ | game | rank | date | ++--+--+ | GTA| 11 | 20081001 | ++--+--+ | SPORE | 1 | 20081103 | ++--+--+ | SPORE | 2 | 20091001 | ++--+--+ | SINSOL |

Re: displaying a specific row within a group by

Andy I want a single SQL query that will return the latest ranking for each game: See Within-group aggregates at http://www.artfulsoftware.com/infotree/queries.php. PB - Andy Sy wrote: Consider the ff. table: ++--+--+ | game | rank | date |

Re: displaying a specific row within a group by

Also: http://jan.kneschke.de/projects/mysql/groupwise-max On Thu, Apr 9, 2009 at 8:46 PM, Peter Brawley peter.braw...@earthlink.net wrote: Andy I want a single SQL query that will return the latest ranking for each game: See Within-group aggregates at