David,
What I am trying to limit this query to is the top 100 details ordered by
SUM(Volume) DESC for each unique LongDescription
For some solutions see 'Within-group quotas (Top N per group)' at
http://www.artfulsoftware.com/infotree/queries.php
PB
-
David Perron wrote:
Hello MySQL Us
On Wed, May 21, 2008 at 9:45 PM, David Perron <[EMAIL PROTECTED]> wrote:
> Hello MySQL Users-
>
> I am pretty sure this is a simple question and I am over thinking how to
> solve the problem, so I am hoping the community can help.
>
> I am selecting a pretty straightforward aggregation from a singl
Hello MySQL Users-
I am pretty sure this is a simple question and I am over thinking how to
solve the problem, so I am hoping the community can help.
I am selecting a pretty straightforward aggregation from a single stats
table with the following format:
SELECT
Description
LongDescriptio
