摘要: 1.MySQL server的语句 -- 查询某年的12个月的数据 SELECT sum( CASE WHEN MONTH ( o.create_time ) = 1 THEN 1 ELSE 0 END ) AS '1月', sum( CASE WHEN MONTH ( o.create_time 阅读全文
posted @ 2022-01-13 14:38 java璀璨小菜鸟 阅读(892) 评论(0) 推荐(0)