创建view的语句如何实现sum前几个月的结果

newkid

jihuyao 发表于 2021-6-26 03:55
A little bit odd but you can build your own dimension table with columns my_month, start, end and cr ...

你这是啥意思？"input" 是怎么传递给视图的？

newkid

从回复时间来看，楼上几位的发帖都被关小黑屋了，如果以后碰到这种情况给我发个站内PM, 要不然可能要关很久。

jihuyao

used term for function like binding parameter for SQL.  Exactly, create the view as described using cross join/where/group and then return the requested month sum,

select c1, ..., sum_val from grouped_view whre my_month='202107' ;

--create month dimension table or view with  (col my_month, start, end)
--create grouped_view as select t1.c1, ..., t2.my_month, sum(t1.val) sum_val from t1, dim_month t2 where t1.month between t2.start and t2.end group by t1.c1, ...,  t2.my_month ;

KEN6503

newkid 发表于 2021-7-12 08:21
就以楼主的例子来创建一个管道函数：create table table1 (col1 number,col2 number, col3 number, col4 nu ...

谢谢。