mysql上一行某些,MySql - 如何获取上一行中的值和下一行中的值？

Barranka..

10

解决方案是使用临时变量:

select

@prev as previous,

e.id,

@prev := e.value as current

from

(

select

@prev := null

) as i,

example as e

order by

e.id

要获取"下一个"值,请重复此过程.这是一个例子:

select

id, previous, current, next

from

(

select

@next as next,

@next := current as current,

previous,

id

from

(

select @next := null

) as init,

(

select

@prev as previous,

@prev := e.value as current,

e.id

from

(

select @prev := null

) as init,

example as e

order by e.id

) as a

order by

a.id desc

) as b

order by

id

可能有点矫枉过正,但它可能对你有帮助