zOs/SQL/TFI027

select count(*)      ,
       TKKEY         ,
       VERFALL
from oa1t.TFI027G1
group by TKKEY         ,
         VERFALL
order by 1 desc
fetch first 100 rows only
;x
with ur
select count(*)      ,
       TKKEY         ,
       VERFALL       ,
       BOERSE        ,
       WHRG          ,
       STATUS        ,
       KURSDATUM
from oa1t.TFI027G1
group by TKKEY         ,
         VERFALL       ,
         BOERSE        ,
         WHRG          ,
         STATUS        ,
         KURSDATUM
order by 1 desc
fetch first 100 rows only
with ur