Given the flexibility of JSONQ, it can be utilized with any data source. Some of the following examples contain their own data. Those that do not reference either the Customer or Product example databases.

json

aggregation

Aggregation operations - simple count

Aggregation operations - conditional count

Aggregation operations - nested count

Aggregation operations - grouped count

Aggregation operations - simple sum

Aggregation operations - projected sum

Aggregation operations - grouped count

Aggregation operations - simple min

Aggregation operations - projected min

Aggregation operations - grouped min

Aggregation operations - min subquery

Aggregation operations - simple max

Aggregation operations - projected max

Aggregation operations - grouped max

Aggregation operations - max subquery

Aggregation operations - simple average

Aggregation operations - projected average

Aggregation operations - grouped average

restriction

Where - simple 1

Where - simple 2

Where - compound query

Where - compound query - alternate query syntax

Where - compound query - full object notation

Where - simple 4

Where - indexed

order

Order - Simple 1

Order - Simple 2

Order - Simple 3

Order - Comparer

Order - Descending Simple 1

Order - Descending Simple 2

Order - Descending Comparer

Order - Multiple with Comparator

Order - Multiple

Order - Multiple Descending Simple

Order - Multiple Descending Comparator

Order - Multiple Descending Comparator

projection

Projection - simple 1

Projection - simple 2

Projection - transformation

Projection - anonymous objects 1

Projection - anonymous objects 2

Projection - anonymous objects 3

Projection - indexed

Projection - filtered

Projection - compound selection 1

Projection - compound selection 2

Projection - compound selection 3

Projection - from assignment

Projection - multiple from

Projection - indexed

join

Cross join

Group join

Cross join with Group join

Left-outer join

element

Element operators - first

Element operators - first conditional

grouping

Grouping - simple 1

Grouping - simple 2

Grouping - simple 3

Grouping - nested

Grouping - anagram comparator

Grouping - anagram comparator with mapping

set

Set operations - distinct 1

Set operations - distinct 2

Set operations - union 1

Set operations - union 2

Set operations - intersect 1

Set operations - intersect 2

Set operations - except 1

Set operations - except 2

quantifiers

Quantifiers - Any

Quantifiers - Any grouped

Quantifiers - All

Quantifiers - All grouped

partition

Partition - simple take

Partition - nested take

Partition - simple skip

Partition - nested skip