[SQL] Datensatz + vorigen/nächsten ermitteln

[mkinzler]

So sollte es eigentlich gehen:

SQL-Code:

SELECT 
    t1.id,
    (SELECT id FROM tab WHERE id < t1.id ORDER BY id DESC LIMIT 1 as vorgaenger,
    (SELECT id FROM tab WHERE id > t1.id ORDER BY id ASC LIMIT 1) as nachfolger
FROM 
    tab t1 WHERE t1.id = MY_ID;