Which SQL clauses are used to construct a recursive query when the number of hierarchy levels is not known in advance? (Select two.)
Exam-Like
Last updated: December 30, 2025 at 14:04
A
CONNECT BY
38.5%
B
LISTAGG
11.5%
C
MATCH RECOGNIZE
11.5%
D
QUALIFY
15.4%
E
WITH
23.1%
Powered ByGPT-5.2
Which SQL clauses are used to construct a recursive query when the number of hierarchy levels is not known in advance? (Select two.) | Snowflake SnowPro Core Quiz - LeetQuiz