Table return the result of two rows in one

Question

if I have a table like this:

MatchCode  TransferId
---------- -----------
17edce4d   7
17edce4d   17
20332cf0   22
20332cf0   30

is it possible make the result return this?

MatchCode  TransferId1 TransferId2
---------- ----------- -----------
17edce4d   7           17    
20332cf0   22          30 

Answer 1

If each MatchCode group will always have only two records, then you can use the MIN and MAX along with a GROUP BY:

SELECT MatchCode, MIN(TransferId) AS TransferId1, MAX(TransferId) AS TransferId2
FROM yourTable
GROUP BY MatchCode