SQL: benachbarte Datensätze mitselektieren

[omata]

Und wenn du deine Abfrage noch sortierst...

SQL-Code:

SELECT username, score, land
FROM user
WHERE score >= (SELECT MAX(score)
                FROM user
                WHERE score < (SELECT MAX(score)
                               FROM user
                               WHERE score < (SELECT score
                                              FROM user
                                              WHERE user_id = 4))) 
ORDER BY score LIMIT 5