📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    ⚡ Month End Offer - Flat 52% Off On All Courses! Enroll Now ⚡
    00:00:00 AM Left

    Question

    Which SQL feature allows hierarchical queries (e.g., org

    chart traversal)?
    A Window functions Correct Answer Incorrect Answer
    B Recursive CTEs Correct Answer Incorrect Answer
    C Views Correct Answer Incorrect Answer
    D Nested subqueries Correct Answer Incorrect Answer
    E Triggers Correct Answer Incorrect Answer

    Solution

    Recursive Common Table Expressions (WITH RECURSIVE) enable hierarchical traversal.

    Practice Next
    ask-question