HELP for group by
From: Ralf Mrowka <ralf.mrowka_at_charite.de>
Date: Fri, 31 May 2002 09:29:29 +0200
Message-ID: <3CF72658.28BE08E9_at_charite.de>
I have the following table
meets none (0) member2 when XX is e.g. 40.
Date: Fri, 31 May 2002 09:29:29 +0200
Message-ID: <3CF72658.28BE08E9_at_charite.de>
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
value is
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 member1
e.g. Ameets none (0) member2 when XX is e.g. 40.
Any help is appreciated!
Thank you!
Ralf Received on Fri May 31 2002 - 09:29:29 CEST