我需要按列组织查询结果,就像它是一个数据透视表一样。我该怎么做呢?
发布于 2018-05-09 05:51:20
相同的方法/结果,但使用的是BigQuery标准SQL:
-- top revised Wikipedia articles containing 'Google'
WITH articles AS (
SELECT title AS page_title,
COUNT(*) AS total
FROM `publicdata.samples.wikipedia`
WHERE REGEXP_CONTAINS(title, r'^Google.+') AND wp_namespace = 0
GROUP BY title
ORDER BY total DESC
LIMIT 5
)
SELECT page_title,
-- Populate these columns as True or False, depending on the condition
IF(page_title LIKE '%search%', total, 0) AS search,
IF(page_title LIKE '%Earth%' OR page_title LIKE '%Maps%', total, 0) AS geo
FROM articles
;
https://stackoverflow.com/questions/19414609
复制相似问题