Arsip: Nilai Kumulatif

more 17 years ago
mas_kofa
aku punya tabel, salah satu fieldnya adalah tanggal dan nilai....
aku ingin melihat nilai kumulatif dari nilai berdasarkan tanggal sehingga hasilnya spt ini :
caranya gmn ya????......... makasih......


more 17 years ago
ImanD
data aslinya mana nih, jd bingung yg mo di kumulatif....
klo aku biasanya sih pke gabungan view az

more 17 years ago
mas_kofa
sorry pertanyaan gak jelas ku perjelas lagi....
aku pake mysql.....
data aslinya adalah field tanggal dan nilai penjualan .....
gmn syntax query biar bisa dapetin kolom kumulatif (penjumlahan nilai sebelumnya).......????

more 17 years ago
ImanD
uppsss aku blom pernah klo di query katanya sih pke store procedure bisa tp blom pernah dilakuin biasanya aku maennya di syntax reportnya atw klo mo ditampilin di grid aku akalin di calculate field....

more 17 years ago
mas_kofa
uppsss aku blom pernah klo di query katanya sih pke store procedure bisa tp blom pernah dilakuin biasanya aku maennya di syntax reportnya atw klo mo ditampilin di grid aku akalin di calculate field....sama dunk.....yg laen..ada yg pernah gak...pake query..???

more 17 years ago
reminder2k1
Mas... Ini aku coba pake MSSQL, dari table TBankMutasi di projectku...
Mgkn mas bisa kembangkan sendiri... Tapi intinya ya spt ini...
moga bisa membantu... :D
DECLARE @Tgl1 AS SmallDateTime
DECLARE @Tgl2 AS SmallDateTime
SET @Tgl1 = '2007-07-01'
SET @Tgl2 = '2007-07-31'
SELECT TBM.Tanggal, SUM(TBM.Jumlah) AS Nilai, SUM(TBM.Jumlah) AS Nilai
FROM TBankMutasi AS TBM
WHERE TBM.Tanggal = @Tgl1
GROUP BY TBM.Tanggal
UNION
SELECT TBM.Tanggal, SUM(TBM.Jumlah) AS Nilai,
(SELECT SUM(Jumlah) FROM TBankMutasi AS TBM2
WHERE TBM2.Tanggal >= @Tgl1
AND TBM2.Tanggal <= TBM.Tanggal)
FROM TBankMutasi AS TBM
WHERE TBM.Tanggal >= @Tgl1+1
AND TBM.Tanggal <= @Tgl2
GROUP BY TBM.Tanggal
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- AUTO REFRESH................
by rykemit in MySQL more 18 years ago - kirim applikasi diatas 50 mb
by agenda in Tip n Trik Pemrograman more 17 years ago - baca data yang belum tampil di lisbox
by megan in Hal umum tentang Pascal Indonesia more 17 years ago - mau tanya delphi prism xe sama delphi xe
by alvonz in OOT more 14 years ago - Cara eksekusi PL/SQL di delphi?
by blacklist in Lain-lain more 17 years ago - Gate Access + Barcode
by ir1keren in Network, Files, I/O & System more 16 years ago - make Dbase via EXCEL
by nurez in onLinux more 19 years ago - error waktu mau menampilkan image
by shindo in Hal umum tentang Pascal Indonesia more 18 years ago - nampilin image bitmap yg disimpan di table ke form
by benyy in Paradox more 18 years ago - Trigger To Delphi
by umarbakri in Hal umum tentang Pascal Indonesia more 18 years ago