PL/SQL:需要帮助根据条件创建计算列。在选择查询中完成

count (DISTINCT ) 如图所示。

SELECT FT.NAME,
  COUNT(DISTINCT
  CASE
    WHEN DATAPAGEID = 1
    THEN 1
    ELSE 0
  END ) Calculated_Column1,
  COUNT(DISTINCT
  CASE
    WHEN DATAPAGEID = 2
    THEN 1
    ELSE 0
  END ) Calculated_Column2,
  ( COUNT(DISTINCT
  CASE
    WHEN DATAPAGEID = 1
    THEN 1
    ELSE 0
  END ) / COUNT(DISTINCT
  CASE
    WHEN DATAPAGEID = 2
    THEN 1
    ELSE 0
  END ) ) * 100||'%' Calculated_Column3
FROM
  ( SELECT 'abc' name, 1 DATAPAGEID FROM dual
  UNION ALL
  SELECT 'abc' name, 1 DATAPAGEID FROM dual
  UNION ALL
  SELECT 'pqr' name, 2 DATAPAGEID FROM dual
  UNION ALL
  SELECT 'pqr' name, 2 DATAPAGEID FROM dual
  UNION ALL
  SELECT 'pqr' name, 3 DATAPAGEID FROM dual
  ) FT
GROUP BY FT.Name
ORDER BY FT.Name;

abc 1   1   100%
pqr 1   2   50%