![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
对于示例表EMP,字段EMPNO为雇员编号,字段MGR为雇员直属经理的编号,KING是最高领导,他的直属经理编号为空,以下哪个语句能查询出JONES及其所有下属
A.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY PRIOR EMPNO=MGR START WITH ENAME='JONES';
B.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY PRIOR MGR=EMPNO START WITH ENAME='JONES';
C.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY EMPNO=PRIOR MGR START WITH ENAME='JONES';
D.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY MGR=EMPNO START WITH ENAME='JONES';