adxrgh
6/15/2017 - 7:52 AM

[选取历史最低价]#tags:sql

[选取历史最低价]#tags:sql

lowest.sql
content_copyfile_download
create view lowest1 as 
select * from stockprice where low in (select  min(low) from stockprice group by secid)
group by secid;

select * from lowest1
where tradedate>'20170501';