子查询
SELECT 列名 [, ..] FROM
(
SELECT 列名 [, ..] FROM YupDB表名 [WHERE YUP_PARTITIONS...]
) tmp
说明:YupDB表不支持多级子查询
WITH 语句
WITH tmp AS
(
SELECT 列名 [, ..] FROM YupDB表名 [WHERE YUP_PARTITIONS...]
)
SELECT 列名 [, ..] FROM
(
SELECT 列名 [, ..] FROM YupDB表名 [WHERE YUP_PARTITIONS...]
) tmp
说明:YupDB表不支持多级子查询
WITH tmp AS
(
SELECT 列名 [, ..] FROM YupDB表名 [WHERE YUP_PARTITIONS...]
)
本文标题:2.4 高级YupDB SQL 教程
本文链接:https://www.haomeiwen.com/subject/dxnyeftx.html
网友评论