|
File: Data.xml
<prices>
<priceList effDate="2006-11-15">
<prod num="1">
<price currency="USD">29.99</price>
<discount type="CLR">10.00</discount>
</prod>
<prod num="2">
<price currency="USD">69.99</price>
</prod>
<prod num="3">
<price currency="USD">39.99</price>
<discount type="CLR">3.99</discount>
</prod>
</priceList>
</prices>
File: Query.xquery
let $bargains := doc("Data.xml")/prices/priceList/prod[price < 30]
return if ($bargains)
then <bargain-bin>{$bargains}</bargain-bin>
else ()
Output:
<?xml version="1.0" encoding="UTF-8"?>
<bargain-bin>
<prod num="1">
<price currency="USD">29.99</price>
<discount type="CLR">10.00</discount>
</prod>
</bargain-bin>
|