Guest_imported
New member
- Jan 1, 1970
- 0
I've taken a look at Volume 5, Chapter 7 and I believe I've come across a syntax problem in the manual.
on page 7-51, Example 2:Group Sum
The query is coded as such:
select city, kind, sales
SUM(sales) OVER (ROWS UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
FROM monthly;
When I attempt to apply this example to my table, I get the error message "3707: syntax error: expected something like ')' between the word 'PRECEDING' and the 'and' keyword".
below is the SQL statement I am attempting to execute via QUERYMAN:
select xref_provider_id, claim_count, sum (claim_count)
over (rows unbounded preceding and unbounded following)
from core_workdb.form_xref_merge;
Any help clearing up this problem will be appreciated.
Thanks in advance.
on page 7-51, Example 2:Group Sum
The query is coded as such:
select city, kind, sales
SUM(sales) OVER (ROWS UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
FROM monthly;
When I attempt to apply this example to my table, I get the error message "3707: syntax error: expected something like ')' between the word 'PRECEDING' and the 'and' keyword".
below is the SQL statement I am attempting to execute via QUERYMAN:
select xref_provider_id, claim_count, sum (claim_count)
over (rows unbounded preceding and unbounded following)
from core_workdb.form_xref_merge;
Any help clearing up this problem will be appreciated.
Thanks in advance.