java自动生成自增id sql查询某表中父列表及父下子的个数？

2021-03-23

2807

sql查询某表中父列表及父下子的个数？select *，(select count(1) from tabname b where b.parentid = a.id) child_countfro

sql查询某表中父列表及父下子的个数？

select *，(select count(1) from tabname b where b.parentid = a.id) child_countfrom tabname a where parentID ="" or parentID is null