10 2022 档案

oracle递归指定层级,oracle递归层级查询 start with ...... connect by prior
摘要：以部门表作为解析 表结构:dept{id:'主键',name:'部门名称',parent_id:'父亲id'} select distinct id from dept where name='' start with id=1 connect by prior id= parent_id orde 阅读全文
posted @ 2022-10-27 14:55 酸牛奶 阅读(189) 评论(0) 推荐(0)