zOs/SQL/WM005UNI

select UWM005, CDEFAULT, D$GUEB, d$guea, w.*
    from oA1P.twm005a1 w
    where (left(twm6, 0) || UWM005, CDEFAULT, D$GUEB) in
          ( select left(twm6, 0) || UWM005, CDEFAULT, D$GUEB
                from oA1P.twm005a1 r
                group by left(twm6, 0) || UWM005, CDEFAULT, D$GUEB
                having count(*) > 1
          )
    order by UWM005, CDEFAULT, D$GUEB
    with ur