汇总数据，帮解答下

[jaway]

有一个表A 字段就一个info 如下

info
A
B
A
C
ff
ss
tg
ff
saf
tgg
dd
..
..
..


我想得到 表B
info信息 出现的次数
A 2
B 1
C 1
ff 2
............

info 表的字段信息是不定的

[wzy_love_sly]

select info,count(1) from tb
group by info

[wzy_love_sly]

select * into 表b select info as 'info信息',count(1) as '出现的次数' from tb group by info

[wzy_love_sly]

create table a (info varchar(20))
insert into a select 'A'
insert into a select 'B'
insert into a select 'A'
insert into a select 'C'
insert into a select 'ff'
insert into a select 'ss'
insert into a select 'tg'
insert into a select 'ff'
insert into a select 'saf'
insert into a select 'tgg'
insert into a select 'dd'

select * into b from (
select info as 'info信息',count(1) as '出现的次数' from a group by info)tp

select * from b

info信息 出现的次数
A 2
B 1
C 1
dd 1
ff 2
saf 1
ss 1
tg 1
tgg 1