Triply Academy - TriplyDB

Triply Academy

academy
Created on Sep 12th, 2018
Members

This query is used to demonstrate how to apply a filter on a group of results using the having clause

Created over 1 year ago, 1 version

order-by

Public

This query shows how to sort the data using the order by clause

Created over 1 year ago, 1 version

This query illustrates how to combine multiple aggregation functions at the same query. For example, min, max, and avg functions

Created over 1 year ago, 1 version

union

Public

This query demonstrates how to use the union keyword

Created over 1 year ago, 2 versions
Created over 2 years ago, 1 version
Created over 2 years ago, 1 version
Created over 2 years ago, 1 version

all

Public
Created almost 3 years ago, 1 version
Created over 3 years ago, 1 version
Created almost 4 years ago, 1 version
Created over 4 years ago, 4 versions
Created over 4 years ago, 5 versions
Created almost 5 years ago, 5 versions
Created almost 5 years ago, 8 versions
Created almost 5 years ago, 2 versions
Created almost 5 years ago, 3 versions
Dataset is not accessible.
Created almost 5 years ago, 2 versions
Dataset is not accessible.
Created almost 5 years ago, 5 versions

Coalesce

Public
Dataset is not accessible.
Created almost 5 years ago, 2 versions
Dataset is not accessible.
Created almost 5 years ago, 1 version

Een voorbeeld van een optional query.

Dataset is not accessible.
Created almost 5 years ago, 4 versions
Created over 5 years ago, 6 versions

Similar to this construct query, but showing the flexibility of returning some results that are deeper in the graph.

This is the flexibility, and therefore predictability, that construct query provide. This makes them a good replacement for the less predictable describe queries.

Created over 5 years ago, 2 versions

This construct query is similar to this describe query, but has predictable results.

Created over 5 years ago, 3 versions
Created over 5 years ago, 2 versions
Created over 5 years ago, 2 versions
Created almost 6 years ago, 5 versions
Created almost 6 years ago, 5 versions
Created about 6 years ago, 2 versions

Aggregate functions can be nested, e.g., to calculate the maximum count.

Created about 6 years ago, 2 versions