Home > Article > Database > 一条sql语句实现统计查询_MySQL

一条sql语句实现统计查询_MySQL

WBOYOriginal: 2016-06-01 13:29:301345browse

bitsCN.com

一条sql语句实现统计查询

如图：程序员在进行如下的统计时，现在提供两种实现方案：

一条sql语句实现统计查询_MySQL

方案一：运用 SEKECT CASE WHEN　

EXPLAIN  SELECT      count(*) AS &#39;总数&#39;,      count(          CASE oup.status          WHEN &#39;1&#39; THEN              oup.id          END      ) AS &#39;未绑定&#39;,      count(          CASE oup.status          WHEN &#39;2&#39; THEN              oup.id          END      ) AS &#39;已绑定&#39;,      count(          CASE oup.status          WHEN &#39;3&#39; THEN              oup.id          END      )AS  &#39;冻结中&#39;  FROM      lab_org_uc_passport oup

显示结果：(按行显示)

一条sql语句实现统计查询_MySQL

方案二：

SELECT  count(*) AS &#39;总数&#39; FROM lab_org_uc_passport oup   UNION ALL  SELECT  count(*) AS &#39;未绑定&#39; FROM lab_org_uc_passport oup WHERE oup.status = &#39;1&#39;  UNION ALL  SELECT  count(*) AS &#39;未绑定&#39; FROM lab_org_uc_passport oup WHERE oup.status = &#39;2&#39;  UNION ALL  SELECT  count(*) AS &#39;未绑定&#39; FROM lab_org_uc_passport oup WHERE oup.status = &#39;3&#39;

显示结果(按列显示)

bitsCN.com

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：MySQL导入.sql文件及常用命令_MySQLNext article：MYSQL IFNULL函数的使用_MySQL

See more

一条sql语句实现统计查询_MySQL

Related articles