[SQL] Datensatz + vorigen/nächsten ermitteln

[omata]

Hallo Matze,

vielleicht so...

SQL-Code:

SELECT a.id, MAX(b.id) prior_id, MIN(c.id) next_id
FROM tab a
LEFT JOIN tab b
  ON a.id > b.id
LEFT JOIN tab c
  ON a.id < c.id
WHERE a.id = :id
GROUP BY a.id

Gruss
Thorsten