本文探讨了如何使用SQL联合查询技术从GIS模块中高效筛选人口和业务相关的数据，通过构建复杂的查询逻辑来实现对特定信息的精确检索。
select * from gis_module where id=(select id from gis_module where display_name like '%人口%')
union
select * from gis_module
start with parent_id=(select id from gis_module where display_name like '%人口%') connect by prior id = parent_id
union
select * from gis_module where id=(select id from gis_module where display_name like '%业务%')
union
select * from gis_module
start with parent_id=(select id from gis_module where display_name like '%业务%') connect by prior id = parent_id
union
select * from gis_module
start with parent_id=(select id from gis_module where display_name like '%人口%') connect by prior id = parent_id
union
select * from gis_module where id=(select id from gis_module where display_name like '%业务%')
union
select * from gis_module
start with parent_id=(select id from gis_module where display_name like '%业务%') connect by prior id = parent_id
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
