Let stateCt : let « XQuery « XML






Let stateCt


File: Data.xml


<order>
  <car dept="A">
    <number>1</number>
    <name language="en">name 1</name>
  </car>
  <car dept="B">
    <number>2</number>
    <name language="en">name 2</name>
  </car>
  <car dept="B">
    <number>3</number>
    <name language="en">name 3</name>
  </car>
  <car dept="C">
    <number>4</number>
    <name language="en">name 4</name>
  </car>
</order>


File: Query.xquery


let $doc := doc("Data.xml")
return $doc//number | $doc//name


Output:

<?xml version="1.0" encoding="UTF-8"?>
<number>1</number>
<name language="en">name 1</name>
<number>2</number>
<name language="en">name 2</name>
<number>3</number>
<name language="en">name 3</name>
<number>4</number>
<name language="en">name 4</name>

 








Related examples in the same category

1.Adding a let clause
2.Using a let clause with a range expression
3.Intermingled for and let clauses