|

楼主 |
发表于 2024-5-28 16:43:28
|
显示全部楼层
可以帮我优化一下这个语句吗:
SELECT a.name,a.date,a.in_de_percent,b.date,b.in_de_percent,c.date,c.in_de_percent ,d.date,d.in_de_percent ,e.date,e.in_de_percent
from stock_data a
JOIN (SELECT name,date,in_de_percent from stock_data) b
JOIN (SELECT name,date,in_de_percent from stock_data) c
JOIN (SELECT name,date,in_de_percent from stock_data) d
JOIN (SELECT name,date,in_de_percent from stock_data) e
ON (a.name=b.name AND a.name=c.name AND a.name=d.name AND a.name=e.name
AND DATEDIFF(a.date,b.date)=1 AND DATEDIFF(b.date,c.date)=1
AND DATEDIFF(c.date,d.date)=1 AND DATEDIFF(d.date,e.date)=1)
WHERE (a.name="001" AND a.in_de_percent<0 AND b.in_de_percent<0 AND c.in_de_percent<0
AND d.in_de_percent<0 AND e.in_de_percent<0) |
|