你即將離開本站

並前往https://support.teradata.com/community?id=community_question&sys_id=2787c3a31b97fb00682ca8233a4bcb82

- COUNT () OVER (PARTITION BY) and DISTINCT - Community

SELECT DISTINCT is processed after the OPAP function and COUNT(DISTINCT) can't be used in OLAP, but in this case you don't need it, just GROUP BY first:

確定！ 回上一頁

查詢 「SQL COUNT(CASE WHEN)」的人也找了：

  1. SQL COUNT(case WHEN group by)
    2.
  2. Count(DISTINCT CASE WHEN)
    3.
  3. SQL SELECT COUNT
    4.
  4. SQL COUNT if
    5.
  5. SQL CASE WHEN
    6.
  6. SQL SUM(CASE WHEN)
    7.
  7. sql count條件
    8.
  8. sql count group by用法
    9.