Re: SQL statement question. Please Help ...

[Quoted] If there is no primary key on a table it is always possible to use ROWID instead
Try this one (AAA is a table name)

select a, b, count(*) c from
 ( select t.a, t.b, t0.rowid r

    from aaa t, aaa t0

    where t.a = t0.a and
          t.b = t0.b and
          t.rowid <= t0.rowid

Jimmy wrote:

> 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
>
> Can I obtain the result by a single SQL statement as follows:
>
> 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 Tue Jul 27 1999 - 23:19:59 CEST