I have a table that contains this information
NoCredit | Client name | compliant | birthday3months |
---|---|---|---|
0300022255 | NORA ESNESTINA | 1 | 0 |
0300022255 | NORA ESNESTINA | 1 | 1 |
0300022255 | NORA ESNESTINA | 1 | 1 |
0300022255 | NORA ESNESTINA | 1 | 1 |
and I want to add a field called Count3Months, this is the result I expect
NoCredit | Client name | compliant | birthday3months | Count3Months |
---|---|---|---|---|
0300022255 | NORA ESNESTINA | 1 | 0 | 3 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
however, when performing a SUM as I am doing here
SELECT
NoCredito,
NombreCliente,
Cumple,
Cumple3Meses,
SUM(Cumple3Meses) Conteo3Meses
FROM Lista
WHERE NoCredito = '0300022255'
I get this result, it does not add that 0
NoCredit | Client name | compliant | birthday3months | Count3Months |
---|---|---|---|---|
0300022255 | NORA ESNESTINA | 1 | 0 | 0 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
0300022255 | NORA ESNESTINA | 1 | 1 | 3 |
How can I get the result I want?
Try as follows: