mysql查询每月不重复的数据_MySQL
- WBOY原创
- 2016-06-01 13:39:231153浏览
比特网 mysql查询每月不重复的数据 Sql代码 mysql> select * from product group by concat(year(last_update),'-',week(last_update),day(last_update)) order by last_update; 或者 Sql代码 mysql> select * from product group by date_format(last_update,'%Y-%m-%d ') order by last_update; Sql代码 ----- ------------------------------------- ------------------ --- |编号 |产品 |最后更新 | ----- ------------------------------------- -------------------- - | 154 | 154新 Ipda-39-76 | | 2012-09-28 10:46:46 | | 155 | 155新 Ipda-64-55-58 | | 2012-09-29 10:46:46 | | 156 | 156新 Ipda-3-61-65 | | 2012-09-30 10:46:46 | | 157 | 157新 Ipda-64-22-41-50 | 2012-10-01 10:46:46 | | 159 | 159新 Ipda-64-36-93-27 | 2012-10-02 10:46:46 | | 160 | 160新 Ipda-3-81-97-69 | 2012-10-03 10:46:46 | | 161 | 161新 Ipda-64-22-99-5-64 | 2012-10-04 10:46:46 | | 122 | 122新 Ipda-71 | 2012-10-05 10:46:46 | | 123 | 123新 Ipda-64-29 | | 2012-10-06 10:46:46 | | 124 | 124新 Ipda-3-34 | | 2012-10-07 10:46:46 | | 59 | 59新 Ipda-39 | | 2012-10-08 10:46:46 | | 60|新 Ipda-64-55 | | 2012-10-09 10:46:46 | | 61 | 61新 Ipda-3-61 | | 2012-10-10 10:46:46 | | 62 | 62新 Ipda-64-22-41 | 2012-10-11 10:46:46 | | 64 | 64新 Ipda-64-36-93 | 2012-10-12 10:46:46 | | 65 | 65新 Ipda-3-81-97 | 2012-10-13 10:46:46 | | 66 | 66新 Ipda-64-22-99-5 | 2012-10-14 10:46:46 | | 1 |新 Ipda | | 2012-10-15 10:46:46 | | 2 |新 Ipda-64 | | 2012-10-16 10:46:46 | | 3 |新 Ipda-3 | 2012-10-17 10:46:46 | | 4 |新 Ipda-64-22 | | 2012-10-18 10:46:46 | | 7 |新 Ipda-64-36 | | 2012-10-19 10:46:46 | | 8 |新 Ipda-3-81 | 2012-10-20 10:46:46 | | 9 |新 Ipda-64-22-99 | | 2012-10-21 10:46:46 | | 15 | 15新 Ipda-3-17 | 2012-10-22 10:46:46 | | 16 | 16新 Ipda-64-22-27 | 2012-10-23 10:46:46 | | 18 |新 Ipda-64-36-38 | | 2012-10-24 10:46:46 | | 19 | 19新 Ipda-3-81-41 | 2012-10-25 10:46:46 | | 20 |新 Ipda-64-22-99-90 | 2012-10-26 10:46:46 | | 34 | 34新 Ipda-3-81-26 | 2012-10-27 10:46:46 | | 35 | 35新 Ipda-64-22-99-10 | 2012-10-28 10:46:46 | | 38 |新 Ipda-3-17-70 | | 2012-10-29 10:46:46 | | 39 | 39新 Ipda-64-22-27-36 | 2012-10-30 10:46:46 | | 41 | 41新 Ipda-64-36-38-44 | 2012-10-31 10:46:46 | | 42 | 42新 Ipda-3-81-41-9 | 2012-11-01 10:46:46 | | 43 | 43新 Ipda-64-22-99-90-13 | 2012-11-02 10:46:46 | ----- ------------------------------------- -------------------- - 集合中 36 行 BitsCN.com