MySQLの閉包テーブル（Closure Table）でルートを取得したい categories ancestor, descendant, depth depth ancestor descendant ancestor == descendant 0 1 2 depth 0 descendant ancestor == descendant SQLis_root RDB MySQL

descendant


select descendant from group by descendant having count(descendant) = 1;