betoesquivel

xquery1

Oct 8th, 2014
489
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SELECT idCategoria, NombreCategoria, XMLQuery(
  2. 'for $x in collection("CatalogoCD")/catalogo/cd
  3. where $x/precio >= 150
  4. return
  5.  <cd id="{$x/@id}">
  6.    <titulo> {$x/titulo}</titulo>
  7.    <año> {$x/año}</año>
  8.  </cd>'
  9. PASSING CatalogoCD RETURNING CONTENT
  10. ) AS CDS
  11. FROM Categorias
  12. WHERE idCategoria > 15 AND idCategoria < 25
Advertisement
Add Comment
Please, Sign In to add comment