CBU's otros Bancos

USE d:\tempo_otros.dbf IN 0 EXCLUSIVE

select substr(alltrim(cbu),1,4) as bco,substr(alltrim(cbu),5,4) as suc,substr(alltrim(cbu),12,11);
as cta,*;
from tempo_otros;
order by 1,2,3

• Consulta de importes y cantidad de agentes por Bancos (para Bancos distintos a Bco Nacion)

select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes;
from tempo_otros;
order by 1 group by bco