SELECT * FROM EMAVG ( ON ibm_stock PARTITION BY name ORDER BY period TargetColumns ('stockprice') StartRows ('10') IncludeFirst ('true') ) ORDER BY period;
SELECT * FROM EMAVG ( ON ibm_stock PARTITION BY name ORDER BY period TargetColumns ('stockprice') StartRows ('10') IncludeFirst ('true') ) ORDER BY period;