资源描述：
《数据库概论 窗口函数(1).pptx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、第8章窗口函数移动平均线多头排列金叉MACD：指数平滑异同平均线KDJBOLLK线分析需求：窗口移动方式滑动窗口：最近跳动窗口：每隔窗口范围基于时间基于行基于值自定义窗口聚集stock_idtrade_dayopen_pricehigh_pricelow_priceclose_pricevolumeamountsz0005942008-08-123.7804.0803.7004.0601292661050557658sz0005942008-08-113.9504.1803.6203.800894108934240973sz0005942008-
2、08-084.1104.1803.9104.020847928334579216sz0005942008-08-073.9604.1203.9504.110449151518259494sz0005942008-08-063.8904.0003.8104.000558219721883585sz0005942008-08-054.0004.0603.9003.900271297010820544sz0005942008-08-044.0704.1704.0104.020405110516574212sz0005942008-07-314.2104
3、.2404.0204.020405153716536682sz0005942008-07-304.2304.2904.1504.250386328516318126sz0005942008-07-294.2404.2704.0904.190475730119864337累积聚集selectS1.stock_id,S1.trade_day,S1.close_price,avg(S2.close_price)asavg_pricefromstockS1,stockS2whereS1.stock_id=S2.stock_idandS2.trade_da
4、y<=S1.trade_daygroupbyS1.stock_id,S1.trade_day,S1.close_priceorderbyS1.stock_id,S1.trade_day累计聚集stock_idtrade_dayclose_priceavg_pricesz0005942008-06-026.1006.1sz0005942008-06-036.0306.065sz0005942008-06-045.9206.01666666666667sz0005942008-06-055.9906.01sz0005942008-06-066.020
5、6.012sz0005942008-06-105.4205.91333333333333sz0005942008-06-114.9505.77571428571429sz0005942008-06-124.9105.6675sz0005942008-06-134.4305.53sz0005942008-06-164.2405.401滑动聚集selectS1.stock_id,S1.trade_day,S1.close_price,avg(S2.close_price)asavg_pricefromstock1S1,stock1S2whereS1.
6、stock_id=S2.stock_idandS2.trade_day<=S1.trade_dayandday(S2.trade_day)+2>day(S1.trade_day)groupbyS1.stock_id,S1.trade_day,S1.close_pricestock_idtrade_dayclose_priceavg_pricesz0005942008-06-026.1006.1sz0005942008-06-036.0306.065sz0005942008-06-045.9205.975sz0005942008-06-055.99
7、05.955sz0005942008-06-066.0206.005sz0005942008-06-105.4205.42sz0005942008-06-114.9505.185sz0005942008-06-124.9104.93sz0005942008-06-134.4304.67sz0005942008-06-164.2404.245,-8,5,5,-8,5,-8,5,5,-8,5窗口函数function_name(,,…)over(8、ng子句>)Partitionby：对表进行分区，类似groupbyOrderby：排序Windowing：窗口函数窗口函数partit
