----- Original Message ----- From: "Danny Kurniawan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 22, 2005 7:45 PM
Subject: Re: [linux-programming] perintah sql
On Mon, 2005-02-21 at 10:16 +0700, riko ms wrote:pake db apa nih? kl mysql, sy pake:
select kode, name, sum(if(month(tgl) = '1'), nilai, 0) as jan, sum(if(month(tgl) = '2'), nilai, 0) as peb, jan+peb as total from name_tabel group by month(tgl)
sori, query ini belum di validasi di mysql :) tp kira2 bgt.
-rik-
ada sedikit ralat:
select kode, name, sum(if(month(tgl) = '1', nilai, 0)) as jan, sum(if(month(tgl) = '2', nilai, 0)) as peb, sum(if(month(tgl) = '1', nilai, 0) + if(month(tgl) = '2', nilai, 0)) as total from name_tabel group by kode, name
di Oracle:
select kode, name, sum(decode(month(tgl), 1, nilai, 0)) as jan, sum(decode(month(tgl), 2, nilai, 0)) as peb, sum(decode(month(tgl), 1, nilai, 0) + decode(month(tgl), 2, nilai, 0)) as total from name_tabel group by kode, name
--
Danny Kurniawan
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS/CM/E/IT d+() s+:+ a- C++>+++$ UL+++(++)>++++ P!(+++) L+++>++++>$ E-- W++>$ N
o-- K- w--(+++) O++@ M@ V? PS PE-@ Y+ PGP@ t++ 5+@ X+++(++) R tv+ b
+++(++) DI? D++@ G+>++ e++ h- r++ y z-
------END GEEK CODE BLOCK------
-- Berhenti langganan: [EMAIL PROTECTED] Arsip dan info: http://linux.or.id/milis
-- Berhenti langganan: [EMAIL PROTECTED] Arsip dan info: http://linux.or.id/milis
