目的:
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
目的:
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