Lines Matching refs:level
732 under_alice(name,level) AS (
735 SELECT org.name, under_alice.level+1
740 SELECT group_concat(substr('...............',1,level*3) || name,x'0a')
758 # The previous query used "ORDER BY level" to yield a breath-first search.
759 # Change that to "ORDER BY level DESC" for a depth-first search.
763 under_alice(name,level) AS (
766 SELECT org.name, under_alice.level+1
771 SELECT group_concat(substr('...............',1,level*3) || name,x'0a')
794 under_alice(name,level) AS (
797 SELECT org.name, under_alice.level+1
801 SELECT group_concat(substr('...............',1,level*3) || name,x'0a')