树查询

 

select * from dvc_device where placeid in(
select id from dvc_place start with id=2879793 connect by prior id=parentid
) and dev_name like '%A相电流互感器%'