Hello there, I have data structure like the following, and each <article> means a xml file or fragment
<article>..... <coden>A</coden> <volume>1</volume> <issue>1</issue>.....</article> <article>..... <coden>A</coden> <volume>2</volume> <issue>6</issue>.....</article> <article>..... <coden>B</coden> <volume>2</volume> <issue>10</issue>.....</article> <article>..... <coden>B</coden> <volume>3</volume> <issue>5</issue>.....</article> <article>..... <coden>C</coden> <volume>3</volume> <issue>10</issue>.....</article> <article>..... <coden>C</coden> <volume>5</volume> <issue>8</issue>.....</article> I want to do a query that similiar with group by and max in sql: I want to group by coden, and for each coden, I want to get max volume number out, also with the max issue for this volume. so the result looks like: <coden>A</coden> <volume>2</volume> <issue>6</issue> <coden>B</coden> <volume>3</volume> <issue>5</issue> <coden>C</coden> <volume>5</volume> <issue>8</issue> Does anyone have any suggestions? Thanks, Helen _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
