mysql - 无论如何让联盟声明更小？

Question

无论如何我可以把这个声明变小吗？为了效率，整个想法是今天、本月和上个月的“报价”数量。

    SELECT COUNT(QuoteDate) AS today
    FROM database
    WHERE QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)

    UNION

    SELECT COUNT(QuoteDate) AS this_month
    FROM database
    WHERE QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)

    UNION

    SELECT COUNT(QuoteDate) AS last_month
    FROM database 
    WHERE QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 2 MONTH)

谢谢

Answer 1

你不能只使用 OR 语句吗？

 SELECT COUNT(QuoteDate) AS today FROM database
    WHERE 
     QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
     OR 
     QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
     OR
     QuoteDate >= DATE_SUB(CURRENT_DATE(), INTERVAL 2 MONTH)