Subject SQL Question
Author Michael Vilhelmsen
SQL Question:

I need to build a SQL statement, but it seems to be more difficut than
expected.

Here is my table (simplified).

ID, Number, Number2
1 10 58
2 10 58
3 11 58
4 11 58
5 12 59
6 12 59
7 12 59



I need to know how many times "Number" is present with a different
"number 1" !
I.e.

58 is pressent 2 times (with number 10 and 11)
59 is present 1 time (with number 12).

Maybe its just me, but I can't seem to get it to work properbly...


Regards
Michael