sql abfrage

[Ahoy]

Hi,

so würde es auch gehen:

SELECT
  id, MAX(name)
FROM
  TABLE(VALUES(12345, 'A'), (12345, 'B'), (98767, 'B'), (98767, 'B')) t(id, name)
GROUP BY
  id
HAVING
  COUNT(DISTINCT name) = 1