How to query the top TWO and the bottom TWO values at the same time in MySql I am able to query the MAX and MIN at the same time but in my case I need the first TWO max and the first TWO min. I am able to query the top two and the bottom two but separately. Like this 

SELECT playerName,teamName, scoreChange,category 
FROM players order by scoreChange desc limit 0,2


and

SELECT playerName,teamName, scoreChange,category 
FROM players order by scoreChange limit 0,2


the following query is working fine but it results only in max and min values . 

SELECT playerName,teamName, scoreChange,category
FROM players
WHERE scoreChange = (SELECT MAX(scoreChange) FROM players)
UNION
SELECT playerName,teamName, scoreChange,category
FROM players
WHERE scoreChange = (SELECT MIN(scoreChange) FROM players)
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