|
Registriert seit: 20. Jan 2006
Ort: Lübbecke
11.475 Beiträge
Delphi 12 Athens
|
AW: Anzahl der Datensatze count(*)
18. Aug 2015, 09:45
Code:
SELECT DISTINCT t1.name,
(SELECT COUNT(*) FROM table1 WHERE table1.name = t1.name AND (table1.name in (table1.FeldA, table1.FeldB, table1.FeldC))) AS cnt
FROM table1 AS t1
Sehr schön! 
|