Subject | SQL Question |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-11-26T13:35:30Z |
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
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