你可以试着做一些类似的事情

INSERT INTO T( country, popolation )
SELECT "North America region" as country, SUM( Population ) as Population
FROM T
WHERE country in ('US','Canada','Mexico')

只需使用下面的SQLINSERT查询。

Insert into TABLE_NAME (Country, Population) 
values ('North American Region', (select sum(Population) from TABLE_NAME));

你必须改变主意 TABLE_NAME 并相应地使用列值。

你可以用卷起来

SELECT country, sum(Population)  as Population
FROM your_table
group by country 
WITH ROLLUP;

或者使用工会

SELECT country, sum(Population)  as Population
FROM  your_table 
group by country
union 
SELECT "North America region", SUM( Population ) as Population
FROM