mysql间隔查询（60条数据每隔2个取一次，取出30条数据）

mysql间隔查询（60条数据每隔2个取一次，取出30条数据）

SELECT
    *
FROM
    ( SELECT
        @i := @i + 1 AS n,
        r.*
    FROM
        ( SELECT YEAR, MONTH, DAY, price, fluctuate FROM business_metal_price_day where type = 1 and status = 0 ORDER BY YEAR DESC, MONTH DESC, DAY DESC limit 60) r,
        ( SELECT @i := -1 ) AS a
    ) AS b
WHERE
    b.n % 2 = 0
    LIMIT 30;