User:Sanhard/Sandbox4

SELECT mytable.id, mytable.date, (       SELECT            MIN(mytablemin.date)        FROM mytable AS mytablemin        WHERE mytablemin.date > mytable.date            AND mytable.id = mytablemin.id    ) AS NextDate FROM mytable