Difference between revisions of "Koleksi Query"
Jump to navigation
Jump to search
Gibransyah (talk | contribs) |
Gibransyah (talk | contribs) |
||
Line 1: | Line 1: | ||
= Date/Time = | = Date/Time = | ||
− | * Hitung penjualan tahunan dikelompokkan per bulan dan per minggu (#mysql) | + | * Hitung penjualan tahunan dikelompokkan per tahun, per bulan, dan per minggu (#mysql) |
+ | |||
+ | <b>Kasus</b> | ||
+ | [[Image:Group-by-week-source.png]] --> [[Image:Group-by-week-result.png]] | ||
+ | |||
+ | <b>Query</b> | ||
SELECT | SELECT | ||
YEAR( tglTransaksiJual ) AS tahun, MONTH( tglTransaksiJual ) AS bulan, | YEAR( tglTransaksiJual ) AS tahun, MONTH( tglTransaksiJual ) AS bulan, |
Latest revision as of 13:31, 13 June 2012
Date/Time
- Hitung penjualan tahunan dikelompokkan per tahun, per bulan, dan per minggu (#mysql)
Kasus -->
Query SELECT YEAR( tglTransaksiJual ) AS tahun, MONTH( tglTransaksiJual ) AS bulan, WEEK( tglTransaksiJual, 5 ) - WEEK( DATE_SUB( tglTransaksiJual, INTERVAL DAYOFMONTH( tglTransaksiJual ) - 1 DAY ) , 5 ) +1 AS minggu, SUM( uangDibayar ) AS total_sales FROM transaksijual GROUP BY tahun, bulan, minggu
Ref http://think-robot.com/2009/04/week-of-the-month-in-mysql/