How to get count of childnodes in XML file using XQuery

Question

I want to get or return the number of item(<recROw></recROw>) in an xml file using the XQUERY. Is there an easy way to do that in XQuery?

Here is my sample XML data:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DailyRecord>
  <recROw>
    <id>1</id>
    <name>John Smith</name>
    <gender>male</gender>
    <status>active</status>
  </recROw>
  <recROw>
    <id>2</id>
    <name>James Bond</name>
    <gender>male</gender>
    <status>active</status>
  </recROw>
<DailyRecord>

Any help and ideas would be appreciated. Thank you in advance!

Mellow

What have you tried? I mean besides asking us. – Fertilizer

u mean number of nodes ? – Zeeland

Yes number of nodes in an item(<recROw></recROw>) – Mellow

Answer 1

Try

count(/DailyRecord/recROw)

Ares

Okay. Sorry I'm just a beginner about XQuery and Java. Thanks for downing! – Mellow

upvoted the question, thank you for posting your question in a precise manner. – Flunky