sql - 在 1 个单行中合并、合并、连接 2 个不同的行 Google SQL | 大查询

Question

我有下表：

| post_state | total_posts |
| opened     | 1000        |
| completed  | 2000        |

我正在使用此查询来获得上述结果：

SELECT post_state,
    SUM(total_threads) as total_posts,
    FROM data.table
    WHERE post_state IN ('opened', 'completed')
    GROUP BY post_state

但是，我想将两行合并为一行，如下所示：

| post_state | total_posts |
| all_posts  | 3000        |

我怎样才能在 Google SQL 中输出这个？我是 SQL 世界的新手，如果你能帮助我，我很高兴 :)

提前感谢您的帮助。

标签： sqlgoogle-bigquery

Answer 1

只需删除GROUP BY post_state：

SELECT 
  'all_posts' as post_state,
  SUM(total_threads) as total_posts,
FROM data.table
WHERE post_state IN ('opened', 'completed')