Calculated field
RAWSQLAGG_STR("MIN(%1)", [label])
Sample data
| label | quantity | amount | flag |
|---|---|---|---|
| cedar cedar | 65 | 12.8 | True |
| ORCHID-west | 66 | -7.6 | False |
| maple-east | 67 | 0 | null |
| willow north | 68 | 25.3 | True |
| birch-birch | 69 | 4.9 | False |
| pine/south | 70 | -1.2 | null |
| ash | 71 | 9 | True |
| null | null | null | null |
The same calculation as SQL
SELECT min(label) AS result FROM input
Runs the example above.
SELECT min(label) AS result FROM input
Written for this dialect; not run here.
SELECT min(label) AS result FROM input
Written for this dialect; not run here.
Result
| result |
|---|
| cedar cedar |
Same rows from the calculation and from the SQL in DuckDB.
Where a naive translation goes wrong
- RAWSQL embeds source-dialect SQL; replace the template for the target database.
Naive SQL
SELECT max(label) AS result FROM input
result willow north Matches the calculation
SELECT min(label) AS result FROM input
result cedar cedar
Signature
RAWSQLAGG_STR(constant_sql, [argument, ...])