美文网首页
sql过滤版本号为3位的

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