20th November 2011
#1
gan,misalny gua punya query keq gini..
SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end
trus misalny gua mau tambahin 1 kolom lagi, misalny namany "total".
total = jumlah + cde
gua coba keq gini tp kolom jumlah invalid katanya
SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end, (jumlah+cde) as total
gimana yah carany?
thanks
</div>
SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end
trus misalny gua mau tambahin 1 kolom lagi, misalny namany "total".
total = jumlah + cde
gua coba keq gini tp kolom jumlah invalid katanya
SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end, (jumlah+cde) as total
gimana yah carany?
thanks
</div>
![]() |
|
|
Terkait
|
||||
| Thread | Forum | |||
| Query | Programming & Web | |||
| [help] sub query | Programming & Web | |||
| [ASK] SQL Query | Programming & Web | |||
| [HELP] SQL query in query | Programming & Web | |||
| [ask] need help for sql query | Programming & Web | |||
Semua waktu adalah GMT +7. Waktu sekarang adalah 05:17 AM.




