Closed
Description
try paste this into a string, i.e. between two quotes "":
SELECT payment_date, amount, sum(amount) OVER (ORDER BY payment_date)
FROM (
SELECT CAST(payment_date AS DATE) AS payment_date, SUM(amount) AS amount
FROM payment
GROUP BY CAST(payment_date AS DATE)
) p
ORDER BY payment_date;
in eclipse it becomes a valid java string in vscode it generates non-compilable code.
Would be great if vscode could help here :)
Metadata
Metadata
Assignees
Type
Projects
Status
✅ Done