求一Oracle sql 语句 计算次数问题

[PowerAMD3794]

表 request

code1 code2

A B

A D

C B

B D

计算每个字母出现的次数 也就是要得到以下结果

code count

A 2

B 3

C 1

D 2

[hongqi162]

create table request(code1 varchar2(10),code2 varchar2(10));
///
insert into request
select 'A','B' from dual
union all
select 'A','D' from dual
union all
select 'C','B' from dual
union all
select 'B','D' from dual;
///
select code,count(code) from
(
select code1 code from request
union all
select code2 code from request
) t
group by code

[PowerAMD3794]

呵呵～ 我也想出来了 和你的方法一样