问题描述

plsql中with as用法问题

with selqtin(value1) as
(select max(adt.inpatient.age) from adt.inpatient);
这条会报错缺失select关键字？

解决方案

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

            自己看着改吧

解决方案二：

这样用
with xxx as (select 语句) select *from xxx；