数据湖探索 DLI-WITH...AS:示例

时间:2024-07-01 21:07:18

示例

将“SELECT courseId FROM course_info WHERE courseName = 'Biology'”定义为公共表达式nv,然后在后续的查询中直接利用nv代替该SELECT语句。

1
WITH nv AS (SELECT courseId FROM course_info WHERE courseName = 'Biology') SELECT DISTINCT courseId FROM nv;
support.huaweicloud.com/sqlreference-dli/dli_08_0186.html