sql过滤版本号为3位的
作者:
majorty | 来源:发表于
2019-03-12 16:45 被阅读0次SELECT ( SELECT p.NAME FROM project p WHERE p.pid = b.project_id ) AS "项目名称" ,
b.version_num AS "版本" ,if(b.static_check_problem_density is NULL ,"--",b.static_check_problem_density) AS "静态问题密度"
FROM dev_score b WHERE b.static_check_problem_density is NULL and b.date >"2018-12-31" and b.date <"2019-04-01"
and (LENGTH(b.version_num) - LENGTH( REPLACE (b.version_num, '.', ''))) <= 2
本文标题:sql过滤版本号为3位的
本文链接:https://www.haomeiwen.com/subject/gepnpqtx.html
网友评论