例
select ID,OyaID,Level, sys_connect_by_path(to_char(ID),',') as path from edaKiri Join dual on ID not in(3,22) start with OyaID is null connect by prior ID = OyaID --亲子条件
order by ID;
1. from句 2. where句 (结合条件) 3. start with句 4. connect by句 5. where句 (行的过滤条件,亲子条件) 6. group by句 7. having句 8. model句 9. select句 10. union、minus、intersect等的集合运算 11. order by句
SELECT各关键字解析执行顺序
最新推荐文章于 2022-05-01 15:46:20 发布