我正在寻找使用单个SELECT语句的帮助。使用两个语句的示例:
第一:从现在算起40天到365天 第二:现在出发到40天
等于所有365天相抵40天后
选择报表1:
SELECT id FROM sales
WHERE (saledate BETWEEN DATE_ADD(NOW(), INTERVAL 40 DAY) AND DATE_ADD(NOW(), INTERVAL 365 DAY))
ORDER BY saledate;选择报表2:
SELECT id FROM sales
WHERE (saledate BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 40 DAY))
ORDER BY saledate;发布于 2014-11-19 00:39:26
为什么不直接使用or
SELECT id
FROM sales
WHERE (saledate BETWEEN DATE_ADD(NOW(), INTERVAL 40 DAY) AND DATE_ADD(NOW(), INTERVAL 365 DAY)) OR
(saledate BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 40 DAY))
ORDER BY saledate;当然,这可以进一步简化:
SELECT id
FROM sales
WHERE saledate BETWEEN (NOW() AND DATE_ADD(NOW(), INTERVAL 365 DAY)
ORDER BY saledate;不过,这似乎太明显了,我可能遗漏了什么。
编辑:
如果这是一个订购问题,那么union all就不是要走的路。工会不能保证结果的顺序。相反,只需:
SELECT id
FROM sales
WHERE saledate BETWEEN (NOW() AND DATE_ADD(NOW(), INTERVAL 365 DAY)
ORDER BY (saledate >= DATE_ADD(NOW(), INTERVAL 40 DAY) ) DESC,
saledate;发布于 2014-11-19 00:04:23
您是否试图使用UNION获得一个组合结果,例如
(SELECT id FROM sales
WHERE (saledate BETWEEN DATE_ADD(NOW(), INTERVAL 40 DAY)
AND DATE_ADD(NOW(), INTERVAL 365 DAY))
ORDER BY saledate)
UNION
(SELECT id FROM sales
WHERE (saledate BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 40 DAY))
ORDER BY saledate)https://stackoverflow.com/questions/27006542
复制相似问题