你可以试试这个：

You may try this:

SELECT userid, testid, catid, max(correct), max(incorrect)
FROM [your table]
GROUP BY userid, testid, catid