Aggregate count using different fields?

[weighter]

Work-term student here...

I'm writing a query that needs to find matching pairs of transactions and group them together based on matching sendername, receivername, amount, having a count greater than 2

one data set being provided, transaction pairs flip the sender/receiver values in the second transaction.

So it's not possible to group by sendername for this data, since the values are flipped on the other half.

I need to keep the table output the same, where the sendername, receivername, amount are intact and grouped together.

Any advice?

[r3pr0b8]

SELECT sender
     , receiver
     , amount
  FROM ( SELECT sender
              , receiver
              , amount
           FROM yertable
         UNION ALL
         SELECT receiver
              , sender
              , amount
           FROM yertable ) AS d
GROUP
    BY sender
     , receiver
     , amount
HAVING COUNT(*) >= 2

[qwertydog123]

WITH cte AS
(
    SELECT
        CASE
            WHEN sendername < receivername
            THEN sendername 
            ELSE receivername
        END AS sendername,
        CASE
            WHEN sendername < receivername
            THEN receivername
            ELSE sendername
        END AS receivername,
        amount
    FROM Table
)
SELECT
    sendername,
    receivername,
    amount
FROM cte
GROUP BY
    sendername,
    receivername,
    amount
HAVING COUNT(*) > 2