Diferencia entre revisiones de «CBU's otros Bancos»
De Wiki
(Página nueva: 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...) |
|||
| Línea 1: | Línea 1: | ||
USE d:\tempo_otros.dbf IN 0 EXCLUSIVE | 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, | + | 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; | from tempo_otros; | ||
| − | order by 1,2,3 | + | order by 1,2,3 |
*Consulta de importes y cantidad de agentes por Bancos (para Bancos distintos a Bco Nacion) | *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; | + | 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 |
Revisión del 16:18 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
