--search select 字段a ,sum(字段b) 字段b from 表1 group by 字段a --create new table select 字段a ,sum(字段b) 字段b into 表2 from 表1 group by 字段a select * from 表2
select 字段a , sum(字段b) from 表1 group by 字段a
select 字段a,sum(字段b) 字段b into 表2 from 表1 group by 字段a
select a,sum(b) b into tb2 from tb group by a order by a
select 字段a ,sum(字段b) 字段b into 表2 from 表1 group by 字段a
DROP TABLE TB DROP TABLE TCREATE TABLE TB (A VARCHAR(10),B INT ) INSERT INTO TB SELECT 'A',50 UNION ALL SELECT 'B',20 UNION ALL SELECT 'C',30 UNION ALL SELECT 'A',20 UNION ALL SELECT 'C',10 --查询 SELECT A,SUM(B) B FROM TB GROUP BY A --创建新表 SELECT A,SUM(B) B INTO T FROM TB GROUP BY A SELECT * FROM T
方法一: select 字段a,sum(字段b) 字段b from 表1 group by 字段a 方法二: select 字段a,sum(字段b) 字段b into tab from 表1 group by 字段a select 字段a ,字段b from tab
CREATE TABLE TB (A VARCHAR(10),B INT ) INSERT INTO TB SELECT 'A',50 UNION ALL SELECT 'B',20 UNION ALL SELECT 'C',30 UNION ALL SELECT 'A',20 UNION ALL SELECT 'C',10 select A,sum(B)B from TB group by A CREATE TABLE TB (A VARCHAR(10),B INT ) INSERT INTO TB SELECT 'A',50 UNION ALL SELECT 'B',20 UNION ALL SELECT 'C',30 UNION ALL SELECT 'A',20 UNION ALL SELECT 'C',10 select A,sum(B)B from TB group by A
select 字段a ,sum(字段b) 字段b from 表1 group by 字段a --create new table
select 字段a ,sum(字段b) 字段b into 表2 from 表1 group by 字段a
select * from 表2
select 字段a , sum(字段b) from 表1
group by 字段a
select 字段a,sum(字段b) 字段b
into 表2
from 表1 group by 字段a
DROP TABLE TB
DROP TABLE TCREATE TABLE TB (A VARCHAR(10),B INT )
INSERT INTO TB
SELECT 'A',50 UNION ALL
SELECT 'B',20 UNION ALL
SELECT 'C',30 UNION ALL
SELECT 'A',20 UNION ALL
SELECT 'C',10
--查询
SELECT A,SUM(B) B FROM TB GROUP BY A
--创建新表
SELECT A,SUM(B) B INTO T FROM TB GROUP BY A
SELECT * FROM T
select 字段a,sum(字段b) 字段b from 表1 group by 字段a
方法二:
select 字段a,sum(字段b) 字段b into tab from 表1 group by 字段a
select 字段a ,字段b from tab
INSERT INTO TB
SELECT 'A',50 UNION ALL
SELECT 'B',20 UNION ALL
SELECT 'C',30 UNION ALL
SELECT 'A',20 UNION ALL
SELECT 'C',10 select A,sum(B)B from TB group by A
CREATE TABLE TB (A VARCHAR(10),B INT )
INSERT INTO TB
SELECT 'A',50 UNION ALL
SELECT 'B',20 UNION ALL
SELECT 'C',30 UNION ALL
SELECT 'A',20 UNION ALL
SELECT 'C',10 select A,sum(B)B from TB group by A
---------- -----------
A 70
B 20
C 40(3 行受影响)