查询树节点及其所有上级节点sql语句

select ID from 表名start with id =节点id connect by prior parentid = id

其中id为表中id标识，parentid为父节点id标识