select kk from (
SELECT ID, xmlserialize(XMLQUERY('declare default element namespace ""; for $w in $ee/外贸销售/销售单/客户编号 return data($w) ' PASSING FXML AS "ee") as char(10)) as kk
FROM TTXML ) group by kk
SELECT ID, xmlserialize(XMLQUERY('declare default element namespace ""; for $w in $ee/外贸销售/销售单/客户编号 return data($w) ' PASSING FXML AS "ee") as char(10)) as kk
FROM TTXML ) group by kk
XMLQUERY('declare default element namespace ""; for $w in $ee/外贸销售/销售单/客户编号 return data($w) ' PASSING FXML AS "ee")
这个是关键点,定义了默认命名空间后,就可以不加上命名空间也可以引用相应XML元素.