(请参阅SQLFiddle以获取本文的工作示例)我有一张股票信息表，如下:sp100_id_datebullishnessagreement----------------------------------------------12011-03-161.010.3312011-03-170.851.2812011-03-180.891.2512011-03-211.461.2112011-03-220.392.5322011-03-163.071.2722011-03-172.090.8022011-03-180.910.1222011-03-211.500.0022011-03-