分級查詢(編輯修改稿)
2024-11-22 19:12 本頁面
【文章內(nèi)容簡介】 arent Key Column2 = Child Key 從底到頂 Column1 = Child Key Column2 = Parent Key 從頂?shù)降妆闅v EMPLOYEES 表 CONNECT BY PRIOR column1 = column2 ... CONNECT BY PRIOR employee_id = manager_id 198 Copyright 169。 Oracle Corporation, 2020. All rights reserved. 遍歷樹 : 從底到頂 SELECT employee_id, last_name, job_id, manager_id FROM employees START WITH employee_id = 101 CONNECT BY PRIOR manager_id = employee_id 。 199 Copyright 169。 Oracle Corporation, 2020. All rights reserved. 遍歷樹 : 從頂?shù)降? SELECT last_name||39。 reports to 39。|| PRIOR last_name Walk Top Dow
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1