SQL语句-递归查询、分组、统计.pdfVIP

SQL语句——递归查询、分组、统计 1 递归查询 1.1 常规做法 select t.orgid, t.parentid, t.orgname from um_organization t where t.orgid=82; select t.orgid, t.parentid, t.orgname from um_organization t where t.orgid=80; select t.orgid, t.parentid, t.orgname from um_organization t where t.orgid=1; 1.2 递归做法 1.2.1 递归做