数据库表如下
CREATE TABLE STOCKITEM(
STOCKDATE DATE NOT NULL,
STOCKCODE CHAR(50) NOT NULL,
STOCKNAME CHAR(50) NOT NULL,
OPENPRICE DOUBLE NOT NULL,
CLOSEPRICE DOUBLE NOT NULL,
HIGHESTPRICE DOUBLE NOT NULL,
LOWESTPRICE DOUBLE NOT NULL,
FLUCTUATEMOUNT DOUBLE NOT NULL, -- 涨跌额
FLUCTUATERATE DOUBLE NOT NULL, -- 涨跌幅
CHANGERATE DOUBLE NOT NULL, -- 换手率
TRADEVOLUME DOUBLE NOT NULL, -- 成交量
TRADEMOUNT DOUBLE NOT NULL, -- 成交金额
TOATLMARKETCAP DOUBLE NOT NULL, -- 总市值
CIRCULATIONMARKETCAP DOUBLE NOT NULL, -- 流通市值
CONSTRAINT pk_a_ss PRIMARY KEY(STOCKDATE,STOCKCODE)
);
我先找出在股票交易记录中可以查询两个交易日内换手率之和的SQL语句