mysql实现隔行相减:
---------------------------------------------------------
WITH T1 AS (
SELECT
TRADE_DATE,
round(
max(HIGH) over (
PARTITION BY trade_date
ORDER BY
trade_date
),
2
) HIGH
FROM
daily
WHERE
ts_code = '000001.SZ'
) SELECT
c.trade_date,
round(now_high - pre_high,2) diff_high,
now_high,pre_high
FROM
(
SELECT
a.trade_date ,@a.high pre_high ,@a.high := a.high now_high
FROM
T1 a,
(SELECT @high := 0) b
) c
---------------------------
实现累减