php – 将两个mysql查询合并为一个

组合这两个查询的正确语法是什么？

SELECT clicks FROM clicksTable WHERE clicks > 199 ORDER BY clicks ASC LIMIT 1

和

SELECT clicks FROM clicksTable ORDER BY clicks DESC LIMIT 1

我试过了：

SELECT clicks FROM clicksTable WHERE clicks > 199 ORDER BY clicks ASC LIMIT 1
UNION
SELECT clicks FROM clicksTable ORDER BY clicks DESC LIMIT 1;

但我得到“UNION和ORDER BY的使用不正确”.

编辑
另外,我希望结果返回一行.这样我就可以访问php中的值了

$row['nextclick'] and $row['topclick'] 

根据Simon的建议,我不应该使用UNION,因为我想返回一行数据 最佳答案 您不能在第一个SELECT中进行ORDER BY,然后UNION它.

编辑
但是你可以

apply ORDER BY or LIMIT to an individual SELECT,place the clause inside the parentheses that enclose the SELECT:

如在MySQL UNION documentation

(SELECT a FROM t1 WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2 ORDER BY a LIMIT 10);

然后,你的SQL

(SELECT clicks FROM clicksTable WHERE clicks > 199 ORDER BY clicks ASC LIMIT 1)
UNION
(SELECT clicks FROM clicksTable ORDER BY clicks DESC LIMIT 1);

编辑2
要返回数组

SELECT (SELECT clicks 
        FROM clicksTable 
        WHERE clicks > 199 
        ORDER BY clicks ASC 
        LIMIT 1) AS NextClick,(SELECT clicks 
        FROM clicksTable 
        ORDER BY clicks DESC 
        LIMIT 1) AS TopClick;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!