如何将三句 mysql 查询合并为一句？
原有三句查询如下：
select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' limit 1 select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' and `version` = 'junior' limit 1 select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' and `version` = 'senior' limit 1
这些查询执行三次，影响效率。可以通过使用 group by 子句将它们合并为一句查询：
SELECT version, COUNT(*) AS tp_count FROM `qra_works` WHERE `created_time` > '2023-05-10 18:44:37' GROUP BY version
此查询将返回版本和相应数量，类似于原始查询的结果。
© 版权声明
文章版权归作者所有，未经允许请勿转载。
THE END
