postgre sql递归查询
时间：2021-07-01 10:21:17
帮助过：17人阅读
AS (
SELECT * FROM [表] WHERE id = xxxunion ALLSELECT [表].* FROM [表], r WHERE [表].id = r.parent_id)SELECT * FROM r ORDER BY id;
递归向上查询数据
postgre sql递归查询
标签：sql递归查询 数据 with font union all nbsp order 查询 col
