Re: Group By With Rollup Question

[Jay Pipes]

(
SELECT
yr
, COUNT(yr) as nr
, ocode
FROM table1
WHERE dc=1
GROUP BY yr, ocode
HAVING COUNT(yr) = 1
)
UNION ALL
(
SELECT
yr
, COUNT(yr) as nr
, ocode
FROM table1
WHERE dc=1
GROUP BY yr, ocode
WITH ROLL UP
) ORDER BY yr, ocode DESC;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com