Select date,symbol,open,high,low,cts.close,volume,lag(cts.close) over (PARTITION by date,symbol) as prevclose,((cts.close - cts.open) / cts.close) * 100 as prcnt
from cts
where cts.close <> 0;
对于整个列prevclose,请保持为空。
Select date,symbol,open,high,low,cts.close,volume,lag(cts.close) over (PARTITION by date,symbol) as prevclose,((cts.close - cts.open) / cts.close) * 100 as prcnt
from cts
where cts.close <> 0;
对于整个列prevclose,请保持为空。
最有可能是由于您正在按date
列进行分区,该列具有时间分量。每个分区都是唯一的,因此没有“ prev”值。
没有LAG
的{{1}}也没有意义。无法保证订单。
ORDER BY
我认为应该是这样的
SELECT ...,lag(cts.close) over (PARTITION by date,symbol) as prevclose
FROM cts;