Koleksi Query

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/