sql abfrage

[Ahoy]

Sicher?

SELECT
  id, COUNT(DISTINCT name) AS cnt
FROM
  TABLE(VALUES(12345, 'A'), (12345, 'B'), (98767, 'B'), (98767, 'B')) t(id, name)
GROUP BY
  id 

Ergibt bei mir:
ID CNT
12345 2
98767 1