zOs/SQL/TXBH111

select count(*) from bua.txbh111;
select count(*), esstate from bua.txbh111
     group by esstate
     order by 1 desc;
select count(*), estype  from bua.txbh111
     group by estype
     order by 1 desc;
select count(*), esstate, estype from bua.txbh111
     group by esstate, estype
     order by 1 desc
     fetch first 10 rows only;
select count(*), ezcount from bua.txbh111
     group by ezcount
     order by 1 desc;
select count(*), EAUUIDHT from bua.txbh111
     group by EAUUIDHT
     order by 1 desc
     fetch first 10 rows only;
select count(*), EAUUIDMQ from bua.txbh111
     group by EAUUIDMQ
     order by 1 desc
     fetch first 10 rows only;
select count(*), EATABNAM from bua.txbh111
     group by EATABNAM
     order by 1 desc
     fetch first 10 rows only;