sql语句查询 有一个菜单有个字段是1,2,3,4,5,6,这是一级菜单,1,2,3,4,5 这五个是1下面的子菜单 1,2,3,4这是2下面的子菜单,以此类推,把这些菜单都查出来,显示在一个树形列表的SQL语句怎么写呀 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from users start with parentid = 1 connect by prior id = parentid SELECT substr(SYS_CONNECT_BY_PATH(ename, '>'),2) "Path" FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; 得到的结果:KINGKING>JONESKING>JONES>SCOTTKING>JONES>SCOTT>ADAMSKING>JONES>FORDKING>JONES>FORD>SMITHKING>BLAKEKING>BLAKE>ALLENKING>BLAKE>WARDKING>BLAKE>MARTINKING>BLAKE>TURNERKING>BLAKE>JAMESKING>CLARKKING>CLARK>MILLER select id , connect_by_root parentid parentid from teststart with parentid in (select parentid from test) connect by prior id = parentid oracle中能不能利用异常的分支来处理正常的逻辑呢? DBMS_SQLTUNE问题 查询表中日期 oracle ebs reports如何实现表尾 请高手解决存储过程 在线求助一条SQL语句 散分.顺便公布一个新的ORACLE和JAVA的群(8412350) select count(*)...和select count(column)...的速度问题 control database- orcl打开特别慢是什么原因 bbed工具的一点疑问 =====求一个复杂的SQL语句或存储过程,谢谢啦,大神们====== Oracle两表关联,这问题怎么解决?(简单)
select *
from users start with parentid = 1
connect by prior id = parentid
FROM scott.emp
START WITH ename = 'KING'
CONNECT BY PRIOR empno = mgr; 得到的结果:
KING
KING>JONES
KING>JONES>SCOTT
KING>JONES>SCOTT>ADAMS
KING>JONES>FORD
KING>JONES>FORD>SMITH
KING>BLAKE
KING>BLAKE>ALLEN
KING>BLAKE>WARD
KING>BLAKE>MARTIN
KING>BLAKE>TURNER
KING>BLAKE>JAMES
KING>CLARK
KING>CLARK>MILLER
select id , connect_by_root parentid parentid from teststart with parentid in (select parentid from test) connect by prior id = parentid