Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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 |
+--------+-----------+
0
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'))
0
+--------+-----------+
| jumlah | bulan |
+--------+-----------+
| 1 | January |
| 2 | May |
| 1 | February |
| 2 | August |
| 1 | September |
| 4 | March |
| 98 | April |
+--------+-----------+
hasilnya gini gan
0
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
0
