How to compare two fields in the same table to see if they match, don't match, or both NULL in SQL with Group By?

Question

I have a table that consists of the following:

Team            ID             
--              --
AB             100001
DC             100001
DC             100032
AB             100021
AB             100032
AB             100044
DC             100044
DC             100323

I would like to see which ID values are align per team (AB & DC both have the same ID present). There are going to be some NULLs/Mismatches due to the size of TEAM AB being 1 million and size of TEAM DC being 50k.

I tried this but doesn't have another Field ID to compare

SELECT Team, ID FROM Table
WHERE ID IN
(
SELECT ID FROM Table
)

My desired output is a new table that shows the fields 'Team' and 'ID' and the third column that shows if they matched or not.

AB         DC           MATCH
--         --            --
100001     100001       TRUE
100032     100032       TRUE
100044     100044       TRUE
100021     100323       FALSE

Answer 1

If you want to get teams that have the same ids, then you can use listagg():

select ids, listagg(team, ',') within group (order by team) as teams
from (select team, listagg(id, ',') within group (order by id) as ids
      from t
      group by team
     ) t
group by ids
having count(*) > 1;