HTML |
---|
<center><font size="5000"> MELHORAR A QUALIDADE DOS DADOS DOEM s2 em 70% </font></center> |
SQL |
---|
|
|
|
|
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Meta | 1649 | 1599 | 1549 | 968 | 924 | 880 | 836 | 792 | 748 | 704 | 660 | 616 | 572 | 549 | ||||||||||||
Real |
| ||
select 'ANTES' AS Tipo,
sum(totalErros) as Reg,
sum(tipoErros) as Itens,
count(*) as Tot
from
(
select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros
from esanTesteAuditorErroInicio
where tipoValidacao = 'V'
group by nuSerie
)
union
select 'DEPOIS' as Tipo,
sum(totalErros) as Reg,
sum(tipoErros) as Itens,
count(*) as Tot
from
(
select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros
from esanTesteFirebirdErro
where tipoValidacao = 'V'
group by nuSerie
)
|