SELECT DATE_FORMAT( tarih, '%m-%Y' ) AS tarih_alani, tarih
FROM table
GROUP BY tarih_alani
ORDER BY tarih ASC