MapReduce服务 MRS-WITH

时间：2025-02-12 15:03:44

MapReduce服务 MRS

WITH

WITH子句定义查询子句的命名关系，可以展平嵌套查询或简化子查询语句。

例如下面的查询语句是等价的：

SELECT name, maxprice FROM (SELECT name, MAX(price) AS maxprice FROM fruit GROUP BY name) AS x;WITH x AS (SELECT name, MAX(price) AS maxprice FROM fruit GROUP BY name) SELECT name, maxprice FROM x;

多个子查询

with t1 as(select name,max(price) as maxprice from fruit group by name),t2 as(select name,avg(price) as avgprice from fruit group by name)select t1.*,t2.* from t1 join t2 on t1.name = t2.name;

WITH的链式形式

WITHx AS (SELECT a FROM t),y AS (SELECT a AS b FROM x),z AS (SELECT b AS c FROM y)SELECT c FROM z;

父主题： HetuEngine DQL SQL语法说明

上一篇：MapReduce服务 MRS-START TRANSACTION:示例

下一篇：MapReduce服务 MRS-START TRANSACTION:示例

开年采购季抽奖赢万元免单

立即前往

续费同价 L实例 2核2G 4M

98元/年

企业专享 X实例 2核4G 5M

198元/年

热门域名 1元随心购

1元/年起

MapReduce服务 MRS-WITH

意见反馈

0/200

提交取消

提交成功！非常感谢您的反馈，我们会继续努力做到更好反馈提交失败！请稍后重试！

MapReduce服务 MRS-WITH

MapReduce服务 MRS-WITH

WITH

7*24

备案

专业服务

退订

建议反馈

售前咨询热线