这可能会对您有所帮助。
select a.id, a.length, coalesce(a.length - (select b.length from foo b where b.id = a.id + 1), a.length) as difffrom foo a
这可能会对您有所帮助。
select a.id, a.length, coalesce(a.length - (select b.length from foo b where b.id = a.id + 1), a.length) as difffrom foo a
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
