adxrgh · June 15, 2017 07:52
diff --git a/lowest.sql b/lowest.sql
 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';
	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';