1、统计空字段缺省率

  1. /* PostgreSql的写法 */
  2. -- 字段缺省率
  3. SELECT counter_null,counter_all,ROUND((counter_null/counter_all::NUMERIC),6) AS perc FROM(
  4.  SELECT
  5. (SELECT COUNT(1)  AS counter_null FROM "scjdgl_qyjyycml" WHERE uniscid IS null),
  6. (SELECT COUNT(1) AS counter_all FROM "scjdgl_qyjyycml")
  7. ) t;
  10. /*  Mysql的写法 */
  11. -- 字段缺省率
  12. SELECT counter_null,counter_all, ROUND((counter_null / counter_all),6) AS perc FROM(
  13. (SELECT COUNT(1)  AS counter_null FROM "scjdgl_qyjyycml" WHERE uniscid IS null) AS t1,
  14. (SELECT COUNT(1) AS counter_all FROM "scjdgl_qyjyycml") AS t2
  15. ) AS a1;
  16. -- 统计统一社会信用代码的无效占比
  17. SELECT counter_invalid,counter_notnull,counter_invalid/counter_notnull FROM(
  18. (SELECT COUNT(1)  AS counter_invalid FROM "scjdgl_qyjyycml" WHERE length(uniscid) < 18) t1,
  19. (SELECT COUNT(1) AS counter_notnull FROM "scjdgl_qyjyycml" WHERE uniscid is not NULL) t2
  20. );