SQL Server 使用SQL创建包含来自另一个表的聚合数据的表

ecfsfe2w 于 2023-01-25 发布在其他

关注(0)|答案(1)|浏览(130)

我尝试从covid_deaths表的聚合数据创建tableau_table_1表。
这是我的疑问...

CREATE TABLE tableau_table_1 AS 
SELECT 
   SUM(new_cases) AS total_cases,
   SUM(cast(new_deaths as int)) AS total_deaths, 
   SUM(cast(new_deaths as int))/SUM(New_Cases)*100 AS death_percentage 
FROM
   covid_data..covid_deaths 
WHERE continent IS NOT NULL
 -- Group By date order by 1,2

我显示的错误是...

Incorrect syntax near the keyword 'from'

sql-server

来源：https://stackoverflow.com/questions/75190921/create-table-with-aggregate-data-from-another-table-using-sql

1条答案

按热度按时间

63lcw9qa1#

您可以尝试SELECT INTO语句

SELECT * INTO tableau_table_1
FROM (
   SELECT 
      SUM(new_cases) AS total_cases,
      SUM(cast(new_deaths AS int)) AS total_deaths, 
      SUM(cast(new_deaths AS int))/SUM(New_Cases)*100 AS death_percentage 
   FROM
      covid_data..covid_deaths 
   WHERE continent IS NOT NULL) AS aggregated_data;

赞(0）回复(0）举报 2023-01-25

我来回答

SQL Server 使用SQL创建包含来自另一个表的聚合数据的表

1条答案

相关问题

热门标签

最新问答