SQL statement question. Please Help ...
From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Wed, 28 Jul 1999 00:26:10 -0700
Message-ID: <379EB092.2892A8D4_at_comp.polyu.edu.hk>
Hello all,
Date: Wed, 28 Jul 1999 00:26:10 -0700
Message-ID: <379EB092.2892A8D4_at_comp.polyu.edu.hk>
Hello all,
I have a table with the following definition: (assume no P.K.)
A number B varchar2(10)
And this table has the following rows:
A B
- -------- 1 AAA 1 AAA 1 AAA 2 BBB 2 BBB 3 CCC
A B C ----- -------- ---------- 1 AAA 1 1 AAA 2 1 AAA 3 2 BBB 1 2 BBB 2 3 CCC 1
i.e. if A and B have the same values, C should be set to number of count of the pair of A and B.
Thanks,
Jimmy
Received on Wed Jul 28 1999 - 09:26:10 CEST