求教这个SQL怎么写？

[hefeifadianchang]

A B 2 ()
B A 1 ()

现在要写SQL，得到

A B 2 (1)
B A 1 (2)

怎么写阿？我比较笨……

[hongqi162]

没看懂 你再解释一下

[hongqi162]

create table t1 (aid varchar2(10))
insert into t1
select '()' from dual
union all
select '()' from dual
union all
select '()' from dual;

update t1 set aid='('||rownum||')'