GBase 8s开发与管理 - start with
type: channel
link: https://www.gbasedbt.com/index.php/tag/start-with/
items: GBase 8s中的start with connect by用法

GBase 8s中的start with connect by用法
type: item
date: 2023-06-12T15:09:00+08:00
description: 如果表中存在层次数据，则可以使用层次化查询子句查询出表中行记录之间的层次关系基本语法：[ START WITH CONDITION1 ] CONNECT BY [ NOCYCLE ] CONDITION2示例：select id,parentid,partname, level from tabpart start with id = 11 connect by nocycle prior id = parentid;[...]