Diferencia entre revisiones de «CBU's otros Bancos»
De Wiki
| Línea 9: | Línea 9: | ||
select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes; | select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes; | ||
from tempo_otros; | from tempo_otros; | ||
| − | order by 1 group by bco | + | order by 1 group by bco into table "T:\acreditacion\0612\estad_otros_bcos |
Revisión actual del 15:20 4 jul 2012
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 into table "T:\acreditacion\0612\estad_otros_bcos
