MySQL distinct和left、right

Question

我有一个包含day列的表，如下所示：

2011-04-28, 2011-04-29 ...
day           count  name surname
2011-04-28    8       titi tutu
2011-04-28     12     tutu toto
2011-04-27     2      tutu toto
2011-03-12     10     tutu toto

我可以得到不同的日期，而不仅仅是月份和年份。

select distinct(day) from Table where day between "2011-03-01" and "2011-04-28";

我只想要不同的月份和年份。

你能帮帮我吗?

谢谢

Answer 1

select DISTINCT EXTRACT(YEAR_MONTH FROM `day`) as yearmonth
from Table
where day between '2011-03-01' and '2011-04-28';

Answer 2

DISTINCT只能应用于mysql中的整行。所以，你需要从日期开始先extract你需要的东西。

select distinct(EXTRACT YEAR_MONTH FROM `day`) from Table 
      where day between "2011-03-01" and "2011-04-28";