with selqtin(value1) as
(select max(adt.inpatient.age) from adt.inpatient);
这条会报错缺失select关键字?
这样用
with xxx as (select 语句) select *from xxx;
SQL> WITH
2 ones_next (col) AS (
3 select 1 from dual
4 union all
5 select 1 + col from ones_next where col < 5
6 )
7 select * from ones_next;
COL
1
2
3
4
5
自己看着改吧