SELECT各关键字解析执行顺序

    技术2025-01-20  5

    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句
    最新回复(0)