Re: Selecting max for each day
A frequently asked question relates to finding the Top-N of an aggregated result, or so-called 'GROUP-WISE MAX' queries.
Various solutions to this problem are provided at the following links:
dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
www.artfulsoftware.com/infotree/queries.php?&bw=1179#101
jan.kneschke.de/projects/mysql/groupwise-max
Edited 1 time(s). Last edit at 11/26/2009 10:22AM by laptop alias.
Subject
Written By
Posted
November 26, 2009 10:12AM
Re: Selecting max for each day
November 26, 2009 10:22AM
November 29, 2009 06:07PM
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.