User Tools

Site Tools


pattern

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
pattern [2017/06/24 15:32]
yzan [Add a new pattern]
pattern [2017/06/24 15:33] (current)
yzan [Patterns]
Line 2: Line 2:
 Patterns describe construction of a predictor. For example //sum// pattern, which sums //column// by //subject// in //table// could be described as: Patterns describe construction of a predictor. For example //sum// pattern, which sums //column// by //subject// in //table// could be described as:
 <code sql> <code sql>
---SumPattern(table,​ column): 
- 
 select subject select subject
-     , sum(column) as predictor¬†+     , sum(@column) as predictor¬†
-from table+from @table
 group by subject; group by subject;
 </​code>​ </​code>​

Page Tools