xml top 问题

SQL SERVER 2008

xml 变量，我们能够取前几条记录吗？类似top 功能

例如

DECLARE @XML AS XML;

SET @XML='
<Name>AA </Name>
<Name>BB </Name>
<Name>CC </Name>
<Name>DD </Name>
<Name>EE </Name>
<Name>FF </Name>
<Name>GG </Name>
'

如果我只想返回前3条记录，该怎么写？

---

SQL code:
select @XML.query('//Name[position()<=3]')

---

SQL code:
DECLARE @XML AS XML;

SET @XML='
<Name>AA </Name>
<Name>BB </Name>
<Name>CC </Name>
<Name>DD </Name>
<Name>EE </Name>
<Name>FF </Name>
<Name>GG </Name>
'

select @XML.query('//Name[position()<=3]')

--<Name>AA </Name><Name>BB </Name><Name>CC </Name>

---

强大
SQL code:
select @XML.query('//Name[position()<=3]')