on 08-31-2010 1:58 PM
hola a todos!!!
tengo una duda en una consulta tengo dos campos T1.credito y T1.debito de la tabla JDT1 como es la estructura del codigo, si quiero mostrar que si la sumatoria de estos dos da negativo los muestre en una columna llamada credito y si da positiva la suma la ponga en una columna llamada debito como queda en el select???
Espero te ayude
select credit + debit as SUMA,
case when credit + debit < 0 then credit + debit else 0 end as Credito,
case when credit + debit >= 0 then credit + debit else 0 end as Debito
from Tabla
Saludos, Jorge
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
muchas gracias fuiste de mucha ayuda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.