HELP for group by
Date: Fri, 31 May 2002 09:29:29 +0200
I have the following table
member1 member2 value
A B 10 A C 11 A L 9 A F 2 B K 10 B O 11
I want to count how often each member1 meets any member2 given that
larger that XX
this works fine with
select member1, count(member2) from table where value<XX group by member1 ;
The problem is that I also want to see in the result member1 if member1e.g. A
meets none (0) member2 when XX is e.g. 40.
Any help is appreciated!
Ralf Received on Fri May 31 2002 - 09:29:29 CEST