UNION 无法将两个结果与同一列合并-PHP中文网问答

文章专题 AI工具学习下载问答源码最近更新

PHP

会员中心讲师中心微信公众号

UNION 无法将两个结果与同一列合并

P粉647504283 2024-04-03 00:23:39

[MySQL讨论组]

599

在这里输入图像描述我试图将这两个查询合并在同一个显示结果中，但是Mysql系统一直说UNION不能在这个位置。如果联合不起作用，我如何组合这两个查询？

P粉647504283

全部回复(1)

P粉3294258392024-04-03 11:58:44 1楼

https://dev.mysql.com/doc/refman /8.0/en/union.html 说：

就您而言，它看起来像这样：

(select customer_id, points, state from customers where state = 'CA' order by points desc limit 3)
union
(select customer_id, points, state from customers where state = 'FL' order by points desc limit 3)

您可能还想了解窗口函数一个>：

select customer_id, points, state
from (
  select customer_id, points, state, 
    row_number() over (partition by state order by points desc) as rownum
  from customers where state in ('CA','FL')
) as t
where rownum