WITH
WI.SELECTTEST AS (
SELECT AREA_ID,AREA_NAME
FROM WI.A_IMC_AREA_BAK)
SELECT AREA_ID FROM WI.SELECTTEST WITH UR;
公共表达式的使用,使用只限于定义表达式的上下文中
也可同时定义多个共同表达式,如下:
WITH
WI.SELECTTEST AS (
SELECT AREA_ID
FROM WI.A_IMC_AREA_BAK),
WI.SELECTTEST1 AS (
SELECT AREA_NAME
FROM WI.A_IMC_AREA_BAK)
SELECT AREA_ID, AREA_NAME FROM WI.SELECTTEST, WI.SELECTTEST1 WITH UR;