sql help?

Codes here !

Moderators: egami, macek, gesf

Post Reply
oaykol
New php-forum User
New php-forum User
Posts: 2
Joined: Sun Jan 14, 2018 7:51 am

Sun Jan 14, 2018 8:02 am

Hi,
I have a table with mixed numbers 1 to 20 in 4 columns like;
  • 1 3 5 7
    1 4 6 7
    2 3 4 7
    1 3 15 16
Now, i want to count all crossing numbers;
1 with 2 = 0
1 with 3 = 2
...to 20
2 with 3 = 1
2 with 4 = 1
... to 20
Is it possible with sql?
Thanks.

User avatar
benanamen
New php-forum User
New php-forum User
Posts: 42
Joined: Mon Oct 16, 2017 1:06 pm

Sun Jan 14, 2018 11:32 am

What is a "Crossing Number"?
The XY Problem
The XY problem is asking about your attempted solution (X) rather than your actual problem (Y). This leads to enormous amounts of wasted time and energy, both on the part of people asking for help, and on the part of those providing help.

oaykol
New php-forum User
New php-forum User
Posts: 2
Joined: Sun Jan 14, 2018 7:51 am

Tue Jan 16, 2018 11:08 am

Sorry for poor English, i mean concurrent numbers, like 1-2 and 1-3 and 2-1 and 2-15 to 20-20

Post Reply