按天数统计涨跌幅超过9.7%的个股支数
select rq,
count(case when zdf>=9.7 then 1 end) ,
count(case when zdf<=-9.7 then -1 end)
from dhq where rq>2015-05-01
group by rq
@唐史主任司马迁 @今日头条 (Ps.感谢 @阿葱 同学协助做Excel图)
按天数统计涨跌幅超过9.7%的个股支数
select rq,
count(case when zdf>=9.7 then 1 end) ,
count(case when zdf<=-9.7 then -1 end)
from dhq where rq>2015-05-01
group by rq
@唐史主任司马迁 @今日头条 (Ps.感谢 @阿葱 同学协助做Excel图)