select a.*, (b.金额-a.金额)/a.金额 from 表 a left join 表 b on a.月份=b.月份 - 1
SELECT MONTH,VALUE,(CAST((VALUE - PREMONTH_VALUE) * 100 / PREMONTH_VALUE AS VARCHAR ) + '%' ) AS 同比增长 FROM (SELECT MONTH,VALUE, (SELECT VALUE FROM TABLE1 B WHERE B.MONTH = A.MONTH - 1) AS PREMONTH_VALUE FROM TABLE1 A) A
SELECT MONTH,VALUE,(CAST((VALUE - PREMONTH_VALUE) * 100 / PREMONTH_VALUE AS VARCHAR
) + '%' ) AS 同比增长
FROM (SELECT MONTH,VALUE,
(SELECT VALUE FROM TABLE1 B WHERE B.MONTH = A.MONTH - 1) AS PREMONTH_VALUE FROM TABLE1 A) A