Oracle Model Clause
SELECT country,prod, YEAR,sales FROM sales_view WHERE country IN ('Italy','Japan')
MODEL RETURN UPDATED ROWS
PARTITION BY (country)
DIMENSION BY (prod, YEAR)
MEASURES (sale sales)
RULES(
sales['Bounce',2002] = sales['Bounce',2001] + sales['Bounce',2000],
sales['Y Box',2002] = sales['Y Box',2001],
sales['2_Products',2002] = sales['Bounce',2002] + sales['Y Box',2002],
sales['2_Products',2003] = 2*sales['2_Products',2002]
)
ORDER BY country, prod, YEAR;
其中红色的部分是可选的。
partition与分析函数中的partition相似，而dimension可以看成是excel中的行与列的值。
MODEL RETURN UPDATED ROWS
PARTITION BY (country)
DIMENSION BY (prod, YEAR)
MEASURES (sale sales)
RULES(
sales['Bounce',2002] = sales['Bounce',2001] + sales['Bounce',2000],
sales['Y Box',2002] = sales['Y Box',2001],
sales['2_Products',2002] = sales['Bounce',2002] + sales['Y Box',2002],
sales['2_Products',2003] = 2*sales['2_Products',2002]
)
ORDER BY country, prod, YEAR;
其中红色的部分是可选的。
partition与分析函数中的partition相似，而dimension可以看成是excel中的行与列的值。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-755013/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
Star Schema
请登录后发表评论
登录
全部评论
