组合2条sql语句
组合2条sql语句
提问于 2016-08-09 23:11:27
我想问一下，有没有人能帮我把这两句话结合起来呢？
SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR))和
SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(CURDATE())我想要实现统计一个人在本年度和前一年的总休假不能超过24 (可以在php端控制)
回答 2
Stack Overflow用户
回答已采纳
发布于 2016-08-09 23:18:48
SELECT * FROM worker_leave
WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR))
OR YEAR(yearAppplied) = YEAR(CURDATE())这将为您提供两个查询的组合结果。
Stack Overflow用户
发布于 2016-08-09 23:17:24
你可以做到
SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR))
UNION
SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(CURDATE())确保两个查询返回的列在结构上是可变的
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/38854484
复制相关文章
相似问题
腾讯云开发者
