Postingan lainnya

Cara ORDER BY MONTH

Master ini biar bisa urut bulannya gimana ? thnks sebelumnya...

 SELECT COUNT(visit_at) AS jumlah, DATE_FORMAT(visit_at,"%M")
AS bulan FROM visitor where YEAR(visit_at) = '2018' GROUP BY bulan ORDER BY MONTH(bulan)

hasilnya


+--------+-----------+
| jumlah | bulan     |
+--------+-----------+
|      1 | January   |
|      2 | May       |
|      1 | February  |
|      2 | August    |
|      1 | September |
|      4 | March     |
|     25 | April     |
+--------+-----------+

php

@fiand96

13 Kontribusi 2 Poin

Diperbarui 6 tahun yang lalu

3 Jawaban:

Coba ini gan:

 SELECT COUNT(visit_at) AS jumlah, DATE_FORMAT(visit_at,"%M")
AS bulan FROM visitor where YEAR(visit_at) = '2018' GROUP BY bulan ORDER BY MONTH(STR_TO_DATE(bulan, '%M'))

@keccikun

364 Kontribusi 196 Poin

Dipost 6 tahun yang lalu

 +--------+-----------+
| jumlah | bulan     |
+--------+-----------+
|      1 | January   |
|      2 | May       |
|      1 | February  |
|      2 | August    |
|      1 | September |
|      4 | March     |
|     98 | April     |
+--------+-----------+

hasilnya gini gan

@fiand96

13 Kontribusi 2 Poin

Dipost 6 tahun yang lalu

 SELECT COUNT(visit_at) AS jumlah, DATE_FORMAT(visit_at,"%M")
AS bulan FROM visitor where YEAR(visit_at) = '2018' GROUP BY bulan ORDER BY MONTH(bulan) ASC

ASC / DESC harusnya begitu gan

@uzzielpelawak

72 Kontribusi 21 Poin

Dipost 6 tahun yang lalu