Code: Select all
SELECT 'abc' AS ctx,
SUM(A.TID) AS TID,
SUM(A.AMT) AS AMT,
SUM(A.BMT) AS BMT,
(SELECT SUM(rzrm)
FROM abcd o) AS rzrm
FROM xyz a
GROUP BY 1
Any suggestions...[Vertica][VJDBC](4818) ERROR: Subqueries in the SELECT or ORDER BY are not supported if the subquery is not part of the GROUP BY