How to query the top TWO and the bottom TWO values at the same time in MySql
You can achieve this by simply following this query as well.

    SELECT * FROM (
            SELECT playerName,teamName, scoreChange,category
            FROM players ORDER BY scoreChange LIMIT 2
        ) AS t1
    UNION
    SELECT * FROM (
            SELECT playerName,teamName, scoreChange,category
            FROM players ORDER BY scoreChange DESC LIMIT 2
        ) AS t2