You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I want to write the NyQL equivalent for following MySQL query that contains WITH ROLLUP. Is there anyway I can achieve this? Could not find this in NyQL wiki.
SELECT year, SUM(profit) AS profit
FROM sales
GROUP BY year ASC WITH ROLLUP;