假如我有一张表test,字段为 id date_submit 两个字段。数据如下:
id date_submit
1 2007-11-13 07:32:14
2 2007-11-14 10:32:14
3 2007-11-16 10:32:14
4 2007-12-14 10:32:14
5 2007-12-16 10:32:14
6 2008-07-10 10:32:14我想按年和月份查询出id,请问哪位高人赐教一下sql语句。
id date_submit
1 2007-11-13 07:32:14
2 2007-11-14 10:32:14
3 2007-11-16 10:32:14
4 2007-12-14 10:32:14
5 2007-12-16 10:32:14
6 2008-07-10 10:32:14我想按年和月份查询出id,请问哪位高人赐教一下sql语句。
where year(date_submit)=2007
and month(date_submit)=11