Michael Vilhelmsen schrieb am 26.11.2004 14:35:

>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).
>
>

select Number2, count(Number1) from Table group by Number2

>
>Regards
>Michael
>
>

Magnus