随笔~~

查询某签名的APP是否存在仿真数据

SELECT EMUL.app_md5, EMUL.count_md5, app_info.app_name, app_info.package_name

FROM

  (

  SELECT app_md5, COUNT(*) as count_md5 FROM app_emul

  WHERE app_md5 IN (

    SELECT app_md5 FROM app_info

    WHERE package_name IN (

          'com.jingdong.app.mall',

          'com.tmall.wireless',

          'com.tencent.mm',

          'com.eg.android.AlipayGphone',

          'com.taobao.taobao',

          'com.netease.newsreader.activity'

    )

  ) GROUP BY app_md5

) AS EMUL

INNER JOIN app_info

ON EMUL.app_md5 = app_info.app_md5