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 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
LongDescription
Detail
SUM(Volume)
FROM StatsTable
GROUP BY Description
LongDescription
Detail
What I am trying to limit this query to is the top 100 details ordered by
SUM(Volume) DESC for each unique LongDescription
This is what I am trying now but its not quite correct, it simply returns
100 of the top details.
SELECT
Description
LongDescription
Detail
SUM(Volume)
FROM StatsTable
GROUP BY Description
LongDescription
Detail
ORDER BY SUM(Volume) DESC
LIMIT 100
What I believe would work is a function in MySQL that is equivalent to the
CUBE function in Oracle.
Any direction would be greatly appreciated!
David
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.24.0/1460 - Release Date: 5/22/2008 7:06 AM
