记录错位方法

目的：

 

 

 

select 
`value` as `value1`,
value2,
t1.time from testvalue as t1
 left join 
( select `value` as `value2`,time from testvalue 
where time > (select time from testvalue order by time asc limit 1 ) ) as t2 
ON t1.time = t2.time