@Select("WITH RECURSIVE topDict AS (" +
"select A.* " +
" FROM base.t00_dict A " +
" WHERE A.parent_dict_id = #{dictId} " +
" UNION SELECT B.* FROM base.t00_dict B " +
" INNER JOIN topDict s ON s.dict_id = B.parent_dict_id " +
") SELECT * FROM topDict ")
List<TreeVo> queryDictTreeByPid(@Param("dictId")String dictId);
WITH RECURSIVE cNode AS (
SELECT A
.*
FROM
dlpt_dm.t20_measure_class_info A
WHERE
A.class_code = '10001'
UNION
SELECT
B.*
FROM
dlpt_dm.t20_measure_class_info B
INNER JOIN topOrg s ON s.class_code = B.parent_class_code
) SELECT
*
FROM
cNode where class_levels='3'
