Query Generate Nomor Urut di MySql

Berikut contoh query untuk menggenerate nomor urut di MySql :

SELECT
    @curRow := @curRow + 1 AS nomor_urut,
    trx.jenis_transaksi, trx.id_matauang, trx.total_transaksi
FROM
    hc_transaksi trx
    JOIN (SELECT @curRow := 0) r

Hasilnya sebagai berikut :

Continue

Query Generate Range Tanggal

Berikut terlampir contoh untuk menggenerate range tanggal :

SELECT 
 a.tanggal 
FROM (
 SELECT 
  CURDATE() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY AS tanggal
 FROM 
 (
  SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 
  UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 
  UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 
  UNION ALL SELECT 9
 ) AS a
 CROSS JOIN 
 (
  SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 
  UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 
  UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 
  UNION ALL SELECT 9
 ) AS b
 CROSS JOIN 
 (
  SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 
  UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 
  UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 
  UNION ALL SELECT 9
 ) AS c
) a
WHERE a.tanggal BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 DAY ) AND CURDATE()
ORDER BY a.tanggal DESC

Tinggal disesuaikan pada bagian

WHERE a.tanggal BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 MONTH ) AND CURDATE()

Hasilnya sebagai berikut :

Continue