How to get 5 records before AND after a record with a specific identifier?

Question

I have a table with a name scoreswith columns idand score. I want to access a specific record on it id, as well as 5 records before and after it. Is there a way in SQL to say "grab a bill with id nand xelements before and after it?"

Answer 1

Try:

  SELECT * 
    FROM scores 
   WHERE score >= n
ORDER BY score ASC
   LIMIT 6

 UNION

  SELECT * 
    FROM scores 
   WHERE score < n
ORDER BY score DESC
   LIMIT 5

The syntax may vary slightly depending on which database server you are using.