随笔分类 -  数据库

摘要：按条件统计四个季度的测单数量 #select sum(case when begin>='20201226' and end<='20210325' then 1 else 0 end) as '一季度', sum(case when begin>='20210326' and end<='2021 阅读全文

摘要：外网映射同其它数据库一致，保证代理名称一致即可，sql server端口号加,号，即可链接成功，如下图所示； 阅读全文

摘要：SELECT p.name, SUM( CASE WHEN b.type = 'codeerror' and b.status = 'active' THEN 1 ELSE 0 END ) AS funs_active, SUM( CASE WHEN b.type = 'codeerror' and 阅读全文

摘要：select resolvedDate from zt_bug WHERE product = '189' and date_format(resolvedDate,'%Y-%m-%d')=date_format(DATE_SUB(CURDATE(), INTERVAL 1 DAY),'%Y-%m- 阅读全文

摘要：select count(*) from zt_bug WHERE date_format(openedDate,'%Y-%m-%d')=date_format(NOW(),'%Y-%m-%d') 阅读全文

摘要：SELECT type, count( * ) AS 激活数量, sum( IF ( severity = 1, 1, 0 ) ) AS 1级数量, sum( IF ( severity = 2, 1, 0 ) ) AS 2级数量, sum( IF ( severity = 3, 1, 0 ) ) 阅读全文

摘要：https://blog.csdn.net/HibonLi/article/details/72897486 SELECT count( * ) as 激活数量,GROUP_CONCAT(a.type separator ';') ,d.severity='1' as 1级BUG,d.severit 阅读全文