这个sql语句该怎么写？

[qinamao]

将a表中的字段 a2,a3 及起内容 组建一个新表 c
用一句话表示

[Rewiah]

select * into c from a

[qinamao]

注意：
1、c 原来并不存在
2、a 中除“a2”“a3”外，还有其他字段

?

[cym7808]

select a2,a3 into c from a

[weitao999]

insert into c select a2,a3 from a

[xiaocong1980]

表c存在
insert into c select * from a
表c不存在
select * into c from a

[pengdali]

select a2,a3 into c from a

[qinamao]

现在我要将表a中的a2='A' 的记录总数和a3='B' 的记录总数分别以字段名a2n、a3n存到新表c中。同样表c原来不存在！咋办？

[jerryvicky]

select a2 'a2n',a3 'a3n' into c from a

[qinamao]

楼上的明显在乱写，
难道没人能写出来吗？

[Rewiah]

select sum(case when a2='A' then 1 else 0 end) as a2n,
sum(case when a3='B' then 1 else 0 end) as a3n
into c from a

or:
select
(select count(*) from a where a2='A') as a2n,
(select count(*) from a where a3='b') as a3n
into c from a

[alexwoowf]

select sum(case when a2='A' then 1 else o end ) as a2n,sum(case when a3='B' then 1 else 0 end)as a3n into tab_c from tab_a

[cym7808]

无法用一条语句表达，因为条件不唯一，可以使用临时表然后UPDATE

[qinamao]

谢谢，接分！

[cym7808]

select distinct
(select count(*) from a where a2='A') as a2n,
(select count(*) from a where a3='B') as a3n
into c from a