per SQL oder RPG doppelte Texte ermitteln

[Fuerchau]

select Text, count(*) from TextTable
Group by Text

oder
select Text, count(*) from TextTable
Group by Text
having count(*) > 1

Da es unterschiedliche Schreibweisen geben könnte:

select hugo.*, count(*) from (
select upper(replace(Text, ' ', '')) from TextTable
) hugo
Group by Text