qq_43040108的博客

mysql删除重复数据只保留一条。

SELECT date as 日期, IFNULL(tab.num, 0) as 数量 FROM (SELECT @cdate := date_add( @cdate, INTERVAL - 1 DAY ) as dateFROM ( SELECT @cdate := date_add(CURDATE(), INTERVAL + 1 DAY ) FROM ccs_work_order )d1 WHERE YEAR(@cdate)=YEAR(CURDATE()) AND MONTH(@cd

当前月份往前推12个月份的数据信息。select DATE_FORMAT(cwo.create_time, '%Y-%m') as createDate, count(case when (cwo.process_method_code = 1 or cwo.process_method_code = 2) then 1 END) as hdCount,count(case when cwo.process_method_code = 3 then 1 END) as siteCountfrom c

MySQL递归查询所有下级节点。先上SQL后来讲解其中的含义。select id from ( select t1.id,t1.inviteId, if(find_in_set(inviteId, @pids) > 0, @pids := concat(@pids, ',', id), 0) as isbig from ( select id,inviteId from cu

SELECTcount(CASE WHEN 字段 = ‘值’ THEN 1 end) as ‘A’,count(CASE WHEN 字段 = ‘值’ THEN 1 end) ‘B’,count(CASE WHEN 字段 = ‘值’ THEN 1 end) ‘C’FROM tableWHERE 条件

需求：根据指定字段将里面不同的值按照我定义的方式排序。select * from table as cwoorder by (case when cwo.work_order_status_code = 1 then 0when cwo.work_order_status_code = 2 then 1when cwo.work_order_status_code = 3 then 2when cwo.work_order_status_code = 4 then 3when cwo.work_

MySQL查询这个月的每一天数量select date_format(create_time, '%Y-%m-%d') as create_time, count(*) as count from table where DATE_FORMAT(create_time,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') and cond = '123456'GROUP BY create_time

SQL查询上个月每一天的数量。SELECT date_format(create_time, '%Y-%m-%d') as create_time, count(*) as count FROM table WHEREdate_format(create_time, '%Y%m') = date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y%m')and cond = '123456'GROUP BY create_time...