--插入测试数据
insert into stock values('600090','2007-01-01','0.1');
insert into stock values('600090','2007-01-02','0.1');
insert into stock values('600001','2007-01-02','0.01');
--查询语句
select *
from stock a left join stock b
on a.stock_no=b.stock_no and a.deal_date = b.deal_date+1
where a.change_rate>0.05 and b.change_rate>0.05;
select a.[编号], a.[名称], [今日涨幅] = a.[涨幅], [昨日涨幅] = b.[涨幅]
from [股票数据表] a,[股票数据表] b
where a.[编号]=b.[编号] and a.[日期]=b.[日期]+1
a.[日期] = @today and [涨幅] >= 10%