betoesquivel icon

xquery4

betoesquivel | PRO | 10/09/14 01:15:00 AM UTC | 0 ⭐ | 498 👁️ | Never ⏰ | []
SQL |

320 B

|

None

|

0 👍

/

0 👎

SELECT idCategoria, NombreCategoria, XMLQuery(
'for $x in collection("CatalogoCD")/catalogo/cd
where count($x/artistas/artista) > 1
return 
  <cd id = "{$x/@id}">
    {$x/artistas/artista}
  </cd>'
PASSING CatalogoCD RETURNING CONTENT
) AS Mas1Autor
FROM Categorias
WHERE NombreCategoria = "Discos más Populares"

Comments