X group-001:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in 1 to 100 let $key := $x mod 10 group by $key return string(text{$x})

 X group-001a:

Created on: 2011-09-14
Spec Dependencies:
spec = XQ30+

Test: for $x in 1 to 100 group by $key := $x mod 10 return string(text{$x})

 X group-002:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee let $key := $x/@gender group by $key return concat($key, ':', string-join(for $e in $x return $e/@name/string(), ','))

 X group-002a:

Created on: 2011-09-14
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee group by $key := $x/@gender return concat($key, ':', string-join(for $e in $x return $e/@name/string(), ','))

 X group-003:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee let $key := ($x/@gender = 'male') group by $key return concat($key, ':', string-join(for $e in $x return $e/@name/string(), ','))

 X group-003a:

Created on: 2011-09-14
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee group by $key := ($x/@gender = 'male') return concat($key, ':', string-join(for $e in $x return $e/@name/string(), ','))

 X group-004:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee let $key := $x/@gender group by $key return concat($key, ':', avg($x/hours))

 X group-005:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee let $key := $x/hours group by $key return <group hours="{$key}" avHours="{avg($x/hours)}"/>

 X group-006:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: <out>{ for $x in //employee group by $key := $x/status return <group status="{$key}" count="{count($x)}"/> }</out>

 X group-007:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: for $x in //employee let $key := $x/hours[1] group by $key where count($x) gt 2 return concat($key, ':', count($x))

 X group-008:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: <out>{ for $x in //employee let $key := $x/empnum group by $key order by count($x), $key return <group count="{count($x)}"> {string-join($x/@name, '|')} </group> }</out>

 X group-009:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: <out>{ for $x in //employee let $key := $x/empnum group by $key collation "http://www.w3.org/2005/xpath-functions/collation/codepoint" order by $key return <group count="{count($x)}" key="{$key}"> {string-join($x/pnum, '|')} </group> }</out>

 X group-009a:

Created on: 2011-09-14
Spec Dependencies:
spec = XQ30+

Test: <out>{ for $x in //employee group by $key := $x/empnum collation "http://www.w3.org/2005/xpath-functions/collation/codepoint" order by $key return <group count="{count($x)}" key="{$key}"> {string-join($x/pnum, '|')} </group> }</out>

 X group-010:

Created on: 2008-11-26
Spec Dependencies:
spec = XQ30+

Test: <out>{ for $x in //employee let $key := if ($x/@gender='male') then number('NaN') else 42 group by $key return <group key="{$key}" count="{count($x)}"/> }</out>

 X group-011:

Created on: 2011-07-24
Spec Dependencies:
spec = XQ30+

Test: for $a at $p in 1 to 10 let $g := $p mod 2 group by $g return string-join($p!string(), ' ')

 X group-012:

Created on: 2011-07-24
Spec Dependencies:
spec = XQ10+
spec = XQ30+

Test: <out>{ for $x in //employee[age > 300] let $key := @gender group by $key return <group gender="{$key}"> { for $e in $x return <person>{$e/@name/string()}</person> } </group> }</out>

 X group-013:

Created on: 2012-06-04
Spec Dependencies:
spec = XQ30+

Test: for $x in 1 to 10, $y in 1 to 4 let $org_y := $y group by $y, $y := $x mod 2 return <grp y="{$org_y[1]}" even="{$y}">{$x}</grp>

 X group-014:

Created on: 2012-10-02
Spec Dependencies:
spec = XQ30+

Test: let $x := 1 return for $i in ("a", "b") group by $x return ($x, count($i))

 X group-015:

Created on: 2012-10-02
Spec Dependencies:
spec = XQ30+

Test: for $x in (true(), "true", xs:QName("true")) group by $x return $x

 X group-016:

Created on: 2012-10-02
Spec Dependencies:
spec = XQ30+

Test: count( for $y in 1 to 10 group by $y := $y, $y := $y mod 2 return $y )

 X group-017:

Created on: 2014-03-24
Spec Dependencies:
feature = non_unicode_codepoint_collation
spec = XQ30+

Test: count( for $y in ("ax", "bx", "cx", "Ay", "By", "Cy") group by $k := substring($y, 1, 1) collation "http://www.w3.org/2010/09/qt-fots-catalog/collation/caseblind" return <group>{$y}</group> )

 X group-018:

Created on: 2014-12-04
Spec Dependencies:
spec = XQ31+
spec = XQ30+

Test: count( for $y in ("ax", "bx", "cx", "Ay", "By", "Cy") group by $k := substring($y, 1, 1) collation "http://www.w3.org/2005/xpath-functions/collation/html-ascii-case-insensitive" return <group>{$y}</group> )

 X group-019:

Created on: 2015-08-04
Spec Dependencies:
spec = XQ30+

Test: let $without_tz := xs:dateTime('2015-04-08T01:30:00') let $with_tz := adjust-dateTime-to-timezone($without_tz, implicit-timezone()) let $keys := (xs:dateTime('2015-04-08T02:30:00'), $without_tz, $with_tz) return count(for $k in $keys group by $k return $k)

 X use-case-groupby-Q1:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <sales-qty-by-product>{ for $sales in $sales-records-doc/*/record let $pname := $sales/product-name group by $pname order by $pname return <product name="{$pname}">{ sum($sales/qty) }</product> }</sales-qty-by-product>

 X use-case-groupby-Q2:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $sales in $sales-records-doc/*/record let $state := $stores-doc/*/store[store-number = $sales/store-number]/state let $category := $products-doc/*/product[name = $sales/product-name]/category group by $state, $category order by $state, $category return <group> <state>{$state}</state> <category>{$category}</category> <total-qty>{sum($sales/qty)}</total-qty> </group> }</result>

 X use-case-groupby-Q3:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $sales in $sales-records-doc/*/record let $state := $stores-doc/*/store[store-number = $sales/store-number]/state, $product := $products-doc/*/product[name = $sales/product-name], $category := $product/category, $revenue := $sales/qty * $product/price group by $state, $category order by $state, $category return <group> <state>{$state}</state> <category>{$category}</category> <total-revenue>{sum($revenue)}</total-revenue> </group> }</result>

 X use-case-groupby-Q4:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $store in $stores-doc/*/store let $state := $store/state group by $state order by $state return <state name="{$state}">{ for $product in $products-doc/*/product let $category := $product/category group by $category order by $category return <category name="{$category}">{ for $sales in $sales-records-doc/*/record[store-number = $store/store-number and product-name = $product/name] let $pname := $sales/product-name group by $pname order by $pname return <product name="{$pname}" total-qty="{sum($sales/qty)}" /> }</category> }</state> }</result>

 X use-case-groupby-Q5:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $sales in $sales-records-doc/*/record let $storeno := $sales/store-number group by $storeno order by $storeno return <store number = "{$storeno}">{ for $s in $sales order by xs:int($s/qty) descending return <product name = "{$s/product-name}" qty = "{$s/qty}"/> }</store> }</result>

 X use-case-groupby-Q6:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $sales in $sales-records-doc/*/record let $storeno := $sales/store-number, $product := $products-doc/*/product[name = $sales/product-name], $prd := $product, $profit := $sales/qty * ($prd/price - $prd/cost) group by $storeno let $total-store-profit := sum($profit) where $total-store-profit > 100 order by $total-store-profit descending return <store number = "{$storeno}" total-profit = "{$total-store-profit}"/> }</result>

 X use-case-groupby-Q7:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $book in $books-doc/*/book for $author in $book/author group by $author order by $author return <author name="{$author}">{ for $b in $book order by $b/title return <title> {fn:data($b/title)} </title> }</author> }</result>

 X use-case-groupby-Q8:

Created on: 2012-03-14
Spec Dependencies:
spec = XQ30+
spec = XQ30+

Test: <result>{ for $book in $books-doc/*/book let $author-list := fn:string-join($book/author, ', ') group by $author-list order by $author-list return <author-list names="{$author-list}">{ for $b in $book order by $b/title return <title> {fn:data($b/title)} </title> }</author-list> }</result>