摘要: with x as ( select 1 as id ,'Adam' as name from dual union all select 2 as id ,'John' as name from dual ) select * from x 这样就构造了一个由两行组成的临时表 如果需要构造临时表来 阅读全文
posted @ 2021-01-26 11:21 一年变大牛 阅读(2986) 评论(0) 推荐(0) 编辑