Query Help - Column must appear in the GROUP BY clause

Hi,

I am not exactly sure what you are trying to accomplish, but all columns NOT listed in the GROUP BY clause need to have an aggregate function.

Example:

dbadmin=> SELECT * FROM temp.rt_test ORDER BY 1, 2, 3, 4;
 HoldingCompanyID | HoldingCompanyName | Metric | Frequency | Spend
------------------+--------------------+--------+-----------+-------
                1 | A                  |      1 |         1 |     1
                1 | A                  |      1 |         1 |     2
                1 | A                  |      2 |         1 |     1
                1 | A                  |      3 |         1 |     1
                2 | B                  |      1 |         1 |     1
(5 rows)

dbadmin=> SELECT
dbadmin-> a.HoldingCompanyID,
dbadmin-> a.HoldingCompanyName,
dbadmin-> a.Metric,
dbadmin-> a.Frequency,
dbadmin-> SUM(a.Spend) AS SpendTotal,
dbadmin-> SUM(SUM(a.Spend)) OVER (PARTITION BY a.Metric, a.Frequency)
dbadmin-> FROM temp.rt_test a
dbadmin-> GROUP BY 1,2,3,4
dbadmin-> ORDER BY 1,2,3,4;
 HoldingCompanyID | HoldingCompanyName | Metric | Frequency | SpendTotal | ?column?
------------------+--------------------+--------+-----------+------------+----------
                1 | A                  |      1 |         1 |          3 |        4
                1 | A                  |      2 |         1 |          1 |        1
                1 | A                  |      3 |         1 |          1 |        1
                2 | B                  |      1 |         1 |          1 |        4
(4 rows)

dbadmin=> SELECT
dbadmin-> a.HoldingCompanyID,
dbadmin-> a.HoldingCompanyName,
dbadmin-> a.Metric,
dbadmin-> a.Frequency,
dbadmin-> SUM(a.Spend) AS SpendTotal,
dbadmin-> MAX(SUM(a.Spend)) OVER (PARTITION BY a.Metric, a.Frequency)
dbadmin-> FROM temp.rt_test a
dbadmin-> GROUP BY 1,2,3,4
dbadmin-> ORDER BY 1,2,3,4;
 HoldingCompanyID | HoldingCompanyName | Metric | Frequency | SpendTotal | ?column?
------------------+--------------------+--------+-----------+------------+----------
                1 | A                  |      1 |         1 |          3 |        3
                1 | A                  |      2 |         1 |          1 |        1
                1 | A                  |      3 |         1 |          1 |        1
                2 | B                  |      1 |         1 |          1 |        3
(4 rows)

Thanks Jim, appreciate it!