记录错位方法目的:???select `value` as `value1`,value2,t1.time from testvalue as t1 left join ( sele
记录错位方法
目的:
?
?
?
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