tenho a seguinte tabela com os valores positivos e negativos, gostaria que fosse gerada uma consulta onde os valores somados desde de que iguais (positivo + negativo) fossem zerados
estado documento nome conta objeto Valor Data
BSB PS juca 99999.99999.090001 10999999 -30,18 05-fev-16
BSB PS paulo 99999.99999.090001 10999999 -12,30 10-fev-16
BSB PS roberto 99999.99999.090001 10999999 -11,61 10-fev-16
BSB PS luiza 99999.99999.090001 10999999 -8,20 12-fev-16
BSB PS luiza 99999.99999.090001 10999999 8,20 12-fev-16
BSB PS roberto 99999.99999.090001 10999999 11,61 10-fev-16
BSB PS paulo 99999.99999.090001 10999999 12,30 10-fev-16
BSB PS juca 99999.99999.090001 10999999 30,18 05-fev-16
BSB PS pedro 99999.99999.090001 10999999 40,18 05-fev-16
ficasse assim, é possivel?
estado documento nome conta objeto Valor Data
BSB PS juca 99999.99999.090001 10999999 0,00 05-fev-16
BSB PS paulo 99999.99999.090001 10999999 0,00 10-fev-16
BSB PS roberto 99999.99999.090001 10999999 0,00 10-fev-16
BSB PS luiza 99999.99999.090001 10999999 0,00 12-fev-16
BSB PS pedro 99999.99999.090001 10999999 40,18 05-fev-16
estado documento nome conta objeto Valor Data
BSB PS juca 99999.99999.090001 10999999 -30,18 05-fev-16
BSB PS paulo 99999.99999.090001 10999999 -12,30 10-fev-16
BSB PS roberto 99999.99999.090001 10999999 -11,61 10-fev-16
BSB PS luiza 99999.99999.090001 10999999 -8,20 12-fev-16
BSB PS luiza 99999.99999.090001 10999999 8,20 12-fev-16
BSB PS roberto 99999.99999.090001 10999999 11,61 10-fev-16
BSB PS paulo 99999.99999.090001 10999999 12,30 10-fev-16
BSB PS juca 99999.99999.090001 10999999 30,18 05-fev-16
BSB PS pedro 99999.99999.090001 10999999 40,18 05-fev-16
ficasse assim, é possivel?
estado documento nome conta objeto Valor Data
BSB PS juca 99999.99999.090001 10999999 0,00 05-fev-16
BSB PS paulo 99999.99999.090001 10999999 0,00 10-fev-16
BSB PS roberto 99999.99999.090001 10999999 0,00 10-fev-16
BSB PS luiza 99999.99999.090001 10999999 0,00 12-fev-16
BSB PS pedro 99999.99999.090001 10999999 40,18 05-fev-16