主页 / 问题 / 1420652
Accepted
Viktor Andriichuk
Asked:2022-08-16 02:34:19 +0000 UTC2022-08-16 02:34:19 +0000 UTC

PostgreSQL：从多列计数

  • 772

大家好。

并告诉我如何转换在 Snowflake 下工作但不想在 PostreSQL 下工作的 SQL。对于雪花来说是这样的：

SELECT
    global_user_id
    , site_lookup_prefix
    , COUNT(global_user_id, site_lookup_prefix) AS count_views
FROM cte_page_view
sql

2 个回答

  1. Best Answer

    如果你相信这个

    就像这样：

    SELECT 
  global_user_id , 
  site_lookup_prefix , 
  COUNT(global_user_id) AS count_views 
FROM 
  cte_page_view
Group by 
  global_user_id,
  site_lookup_prefix

    也许缺少条件：

    Where
  not global_user_id is null
  and not site_lookup_prefix is null
    • 1

  2. 如果我理解正确：

    SELECT
    global_user_id
    , site_lookup_prefix
    , COUNT(*) AS count_views
FROM cte_page_view
group by global_user_id, site_lookup_prefix;
    • 1

相关问题