SELECT
*
FROM
(
SELECT
d.*,
( SELECT count( 1 ) FROM talbe dd WHERE dd.parent_id = d.id ) AS count
FROM
talbe d
) a
WHERE
a.count = 0
MySQL查询所有叶子节点
最新推荐文章于 2023-12-12 13:52:37 发布
SELECT
*
FROM
(
SELECT
d.*,
( SELECT count( 1 ) FROM talbe dd WHERE dd.parent_id = d.id ) AS count
FROM
talbe d
) a
WHERE
a.count = 0