I have a table which has one user ID mapped to multiple user IDs. I want to get the common user IDs mapped to each of the two user IDs
My Data looks in the following way
User ID User ID 11 21 31 41 51 61 71 81 92 12 32 52 72 92 112 132 152 17. .. .. .. .. .. .2000 2001
I need to get for every User ID combination starting from (1,2) till (1999,2000) how many common User ID1's are there
Thanks in advance for any solution
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.