count_distinct
-
PostgreSQL的查询技巧: 零除, GENERATED STORED, COUNT DISTINCT, JOIN和数组LIKE
零除的处理 用NULLIF(col, 0)可以避免复杂的WHEN…CASE判断, 例如 ROUND(COUNT(view_50.amount_in)::NUMERIC / NU…
零除的处理 用NULLIF(col, 0)可以避免复杂的WHEN…CASE判断, 例如 ROUND(COUNT(view_50.amount_in)::NUMERIC / NU…