SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

Explain CONNECT BY PRIOR?

SQL Interview Question
SQL Interview Question

Answer:

Retrieves rows in hierarchical order eg.
select empno, ename from emp where.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is SQL sub-query?Explain UNION, MINUS, UNION ALL and INTERSECT?