34,576
社区成员
发帖
与我相关
我的任务
分享
--试试exists
create table tb(name xml)
insert into tb
select '<ExtField><Quality>一般</Quality><CityCode>3301</CityCode></ExtField>' union
select '<ExtField><Quality>一般</Quality><CityCode>3301</CityCode></ExtField>' union
select '<ExtField><Quality>高端</Quality><CityCode>3303</CityCode></ExtField>' union
select '<ExtField><Quality>中等</Quality><CityCode>3302</CityCode></ExtField>'
select count(*) from tb where name.exist('(.[ExtField/Quality="一般"])[1]')=1