Contoh sum pada SQL
SELECT SUM(KOLOMA),
SUM (
KOLOM01 + KOLOM02 + KOLOM03 + KOLOM04 + KOLOM05 +KOLOM06
+ KOLOM07 + KOLOM08 + KOLOM09 + V_AKB_BULAN10 + KOLOM11 + KOLOMN
)
AS total FROM KOLOMX t WHERE JENIS_KELAMIN ='P'
SELECT SUM(KOLOMA),
SUM (
KOLOM01 + KOLOM02 + KOLOM03 + KOLOM04 + KOLOM05 +KOLOM06
+ KOLOM07 + KOLOM08 + KOLOM09 + V_AKB_BULAN10 + KOLOM11 + KOLOMN
)
AS total FROM KOLOMX t WHERE JENIS_KELAMIN ='P'
0 Response to "Contoh sum pada SQL"
Post a Comment