主页 / dba / 问题 / 98223
Accepted
zeeshan
Asked: 2015-04-19 10:33:22 +0800 CST

错误：UNION 和 ORDER BY 的使用不正确

  • 772

我有这个查询：

SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`)) 
from wp_result_plugin 
WHERE Bet=2 
AND month(`Date`) = EXTRACT(month FROM (NOW())) 
ORDER BY MONTH(`Date`) ASC

UNION 

SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`)) 
from wp_result_plugin 
WHERE Bet=2 
AND month(`Date`) 
ORDER BY MONTH(`Date`) ASC

我看到这个错误：

Incorrect usage of UNION and ORDER BY

如何使这项工作？

mysql-5.5 mysqli

1 个回答

  1. Best Answer

    将选择包装到括号中

    (SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`)) from wp_result_plugin WHERE Bet=2 AND month(`Date`) = EXTRACT(month FROM (NOW())) ORDER BY MONTH(`Date`) ASC )
UNION 
(SELECT DISTINCT CONCAT (MONTH(`Date`),'-',YEAR(`Date`)) from wp_result_plugin WHERE Bet=2 AND month(`Date`) ORDER BY MONTH(`Date`) ASC)
    • 3

相关问题