一个表中一次性分类返回满足不同条件的数据

最新推荐文章于 2022-02-11 11:44:21 发布

Curtain-Stu

最新推荐文章于 2022-02-11 11:44:21 发布

阅读量841

点赞数

分类专栏： MySQL 文章标签： select

本文链接：https://blog.csdn.net/stulcc/article/details/65446833

版权

MySQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

select distinct h.device_id,
(select count(*) from print_task_hist a where a.device_id = h.device_id where…(条件一)… ) as yesterDayTotal,
(select count(*) from print_task_hist a where a.device_id = h.device_id where…(条件二)… ) as currentMonthTotal,
(select count(*) from print_task_hist a where a.device_id = h.device_id where…(条件三)… ) as previousMonthTotal
from print_task_hist h;

SELECT w.wx_original_id AS “wxOriginalId”,
(SELECT count(*) as total FROM print_task_hist a where a.wx_original_id = w.wx_original_id) AS “yesterDayTotal”
FROM
(SELECT DISTINCT wx_original_id FROM print_task_hist WHERE device_id = ‘7vt4hnou2a’) w

ibatis查询SQL语句返回一个对象，此对象包含一个List属性